May 3, 2002 at 12:35 pm
We have a SQL 2000 server running a T-SQL job that does some local file processing and record updates. Then the job updates a table on a linked server. Up until recently, the linked server was running SQL7.0. Then they upgraded to SQL2000. Now when I do an updated on the linked server, the records are actually updated, but I get a result of 0 records updated. Unfortunately this is part of my error checking procedure; to check how many records were updated.
I have found the NOCOUNT flag user option and we are having that checked out, but I was wondering if there are any other reasons why this is happening.
May 3, 2002 at 1:09 pm
Duplicate post, see responses at http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=4011&FORUM_ID=8&CAT_ID=1&Topic_Title=0+Rows+Updated+%2D+NOT&Forum_Title=T%2DSQL
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply