April 23, 2008 at 9:37 pm
Hi
I have a problem with a job with 3 sp one step for each sp, stopped in step 2, my server is SQL2005 SP1 and win 2003 linked with server sql 2000 sp4 win 2000 sp4, in march I appplied a patches from Microsoft, since this time the job send a message
Executed as user: NT AUTHORITY\SYSTEM. The OLE DB provider "MSDASQL" for linked server "curehost" reported an error. Execution terminated by the provider because a resource limit was reached. [SQLSTATE 42000] (Error 7399) Cannot execute the query "SELECT "Tbl1008"."HistoryId" "Col1035","Tbl1008"."ActualCount" "Col1038" FROM "ccm"."dbo"."ProductionItemHistory" "Tbl1008" WHERE "Tbl1008"."ItemTypeId"='AHNORM' OR "Tbl1008"."ItemTypeId"='NORMAL' ORDER BY "Col1035" ASC" against OLE DB provider "MSDASQL" for linked server "curehost". [SQLSTATE 42000] (Error 7320) 001 [SQLSTATE 01000] (Error 0) 002 [SQLSTATE 01000] (Error 0) OLE DB provider "MSDASQL" for linked server "curehost" returned message "[Microsoft][ODBC SQL Server Driver]Timeout expired". [SQLSTATE 01000] (Error 7412). The step failed.
Script to create a Linked server
EXEC master.dbo.sp_addlinkedserver @server = N'curehost', @provider=N'MSDASQL', @provstr=N'DRIVER={SQL Server};SERVER= ;'
Please help me to resolve this problem.
Thanks a lot.
April 24, 2008 at 3:46 am
this may be a stupid question, but have you uninstalled the patches and try to re-run the job?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy