Home Forums SQL Server 2005 SQL Server 2005 General Discussion Bizzare sp_makewebtask issue RE: Bizzare sp_makewebtask issue

  • December 6, 2007 at 5:44 pm

    #757919

    I've got two ideas to look at:

    one is related to cross database chaining:

    one command points to one database, and the other points to a different one ...which is correct?

    set @muusid = '#CAELS1'

    set @SQL = 'select top 10 * from bpcssql.dbo.itemmasternew_bpcs'

    --set @SQL = 'execute icg.dbo.SP_MM_ITEMSTATUS ' + '''' + @muusid + ''''

    the other thing is are you sure the stored procedure has SET NOCOUNT ON at the top?

    you can get wierd results like you are describing if the store proc will return results, but doesn't have that command at the top.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!