Linked Server

• espinfire

  SSC Veteran

  Points: 210

  More actions

  April 23, 2008 at 9:37 pm

  #124889

  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.

• gino.adriaans

  SSC Journeyman

  Points: 89

  More actions

  April 24, 2008 at 3:46 am

  #806433

  this may be a stupid question, but have you uninstalled the patches and try to re-run the job?