SQL TIMEOUT

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

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

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