Post reply

How to set query timeout server level?

  • August 26, 2003 at 10:09 am

    #358235

    Does anybody know how one can be set query timeout for any connection to a SQL Server, controlled by SQL server itself?

  • August 26, 2003 at 10:45 am

    #471461

    I don't think so. There is 'remote query timeout' and 'query wait' in sp_configure, and of course query governor cost limit. I've also looked for this feature and didn't find a single setting.

  • August 26, 2003 at 11:35 am

    #471469

    Any clue how to tweak SQL Server settings for query timeout.

  • August 27, 2003 at 5:08 am

    #471571

    Have a look on the SQL server properties in the Enterprise Manager. The Connections tab, section Remote Server Connections allows to determine the query timeout for remote server connections.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply