• river (7/13/2009)


    If i install only the client tools (management studio) on a desktop, when i connect to this server trought this GUI and make a query, this query is not affected by the remote timeout?

    what about , if i have an application (VB app.) that is installed on my desktop. this app uses a connection string to connect to the server. when the app sends commands (SQL) to the server it is not affected my the remote timeout too?

    No. Neither of those will be affected by the remote query timeout setting within SQL server. The timeout of those will be configured within the app's code. Management studio you can change it using the query options (Query menu) or in the login properties when you connect to the server. The VB app will have set it using the command timeout property somewhere in the code (ado). In either case it just applies to the connection that the setting is made on, no others.

    The server doesn't know anything about a timeout. A timeout is what the connecting client specifies as the amount of time it is willing to wait for something to complete. SQL does not restrict how long it will run a query for.

    The remote query timeout setting is used only when the SQL server that the setting is configured on connects to another database engine and runs a remote query. This is done across a linked server (with 4 part naming or OPENQUERY) or with an ad-hoc remote call OPENROWSET

    Note - I configure remote timeout of this server on my machine. I register the SQL Server instance, trought the GUI (m.s) , then i click on properties in the instance registered. Then , choose connections option, and then i define the values.

    That's the login and execution timeout, not remote timeout. Remote timeout is set using sp_configure.

    exec sp_configure 'remote login timeout (s)'

    exec sp_configure 'remote query timeout (s)'

    Now, what exactly are you asking about, login timeout, execution timeout or remote timeout? They're three very different things.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass