Post reply

odd error message in function in a proc

  • August 19, 2019 at 7:34 pm

    #3672461

    I have a cursor which has calls a function (sorry for  design this is a 3rd party db).  Odd part is there are 10 rows in the cursor select, only every other row gets updated, next row gets error below.  This happens no matter what the sort order is, one row works, next row errors, next row works, next row errors until all 10 rows are done

     

    Msg 7202, Level 11, State 2, Line 26

    Could not find server 'update images set image_data=(select myimage' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

  • August 19, 2019 at 7:43 pm

    #3672462

    Is UPDATE statement being dynamically constructed? If so, print it out and see if it's correct.

    --Vadim R.

  • August 19, 2019 at 8:17 pm

    #3672484

    You'd need to post the actual code that processes the cursor for us to really accurately help.

    But, likely an extra FETCH is being issued.  People insist on coding multiple FETCH statements when processing a cursor, and doing the FETCH at the end of the loop, and that can cause issues.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply