Did you receive the following error while using an OPENQUERY() statement?
OLE DB provider “SQLNCLI1″ for linked server “[LinkedServerName]” returned message “Query timeout expired”.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider “SQLNCLI1″ for linked server “[LinkedServerName]” reported an error. Execution terminated by the provider because a resource limit was reached.
Msg 7320, Level 16, State 2, Line 1
Cannot execute the query ”
Try adding a TOP clause, example:
SELECT TOP 250000 * .....
If the error still occurs , increase the timeout settings in the Server Properties window or Linked Server Properties window.
No comments:
Post a Comment