I get the message - "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" - when working with large tables in Management Studio.
If you change the Execution time-out you need to open a new query over a new connection:
File -> New -> Database Engine Query
Instead of changing the execution time-out through Tools -> Options you should be able to specify it when opening the first query/connection to a SQL Server in the "Connect to Database Engine" dialog box:
Options -> Execution time-out.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment