I am running a script to bring in data from our SourceServer (SS2008) to our DestServer (SS2005). SourceServer was SS2005, we had no issues even with timeout set to 600. With SS2008, the same script is timing out well before 600 timeout setting. To be on safer side, I changed the timeout setting from 600 (10 minutes) to 0 (unlimited). Following is the error message:
OLE DB provider "SQLNCLI" for linked server "SourceServer" returned message "Query timeout expired".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "SQLNCLI" for linked server "SourceServer".
Thanks for your help.