SQL TIMEOUT

schuitkds
schuitkds used Ask the Experts™
on
Stupid question but Newbie here
How do I change the timeout value for a sql server database
sql server 2005
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Awarded 2008
Awarded 2008

Commented:
You change your connection value through your provider....ie, you set it through your code when you make your connection.

Commented:
You need to set it from application end. From SQL Server end, you can execute this query to set the remote query timeout as below:
1. Connect to SQL Server Enterprise Manager/Management Studio (depending on SQL 2000/2005)
2. Execute the below queries in order

a. sp_configure 'show advanced options', 1
    go
    reconfigure with override

b. sp_configure 'remote query timeout (s)', <desiredvalue in milliseconds>
    go
    reconfigure with override

Author

Commented:
so the client that connects to the database, you set the time out there.
so if I am using ms access to pull data from the sql database I change the timeout value in access?

If we have a web based front end to the database you change the timeout value on the web server program.

Just want to make sure I have this straight
thank you
Commented:
Yes..you are right!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial