August 19, 2019 at 7:34 pm
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
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
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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply