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.