• I'm sorry Gail, but i still didn't undestud something about this post.

    "No. The remote timeout only affects commands that are remote to this server. ie commands that the SQL Instance with that configured on runs against a different server. Either via linked servers (openquery, 4-part naming) or ad-hoc remote calls (openrowset)

    Timeout is always a client setting, so it's set on whatever the client is and if affects the remote server. If you want your management studio queries to timeout (why?), you need to set the timeout within the client, ie management studio.

    "

    i.e - suppose i have a server named SRV1 whitch is a Database server.

    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?

    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.