Is it possible to set a timeout for a SQL query on Microsoft SQL Server?

by

As far as I know, apart from setting the command or connection timeouts in the client, there is no way to change timeouts on a query by query basis in the server.

You can indeed change the default 600 seconds using sp_configure, but these are server scoped.

More Related Contents:

  1. Forcing a query timeout in SQL Server
  2. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  3. Max Nbr of Months W/ No Activity in Past 12 Months
  4. Export from SQL Server to Excel
  5. SQL server query to output the data shown below
  6. hide/remove header and footer
  7. How to use a variable for the database name in T-SQL?
  8. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  9. Create a view with ORDER BY clause
  10. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  11. INSERT INTO vs SELECT INTO
  12. Possible to store value of one select column and use it for the next one?
  13. How to view transaction logs in SQL Server 2008 [closed]
  14. Scheduled run of stored procedure on SQL server
  15. How can I change from SQL Server Windows mode to mixed mode (SQL Server 2008)?
  16. How can I Insert data into SQL Server using VBNet
  17. Retrieve data from stored procedure which has multiple result sets
  18. How can I get the sum of multiple datetime values?
  19. Running an SSIS Package using dtexec
  20. Use of Begin / End Blocks and the Go keyword in SQL Server?
  21. Last executed queries for a specific database
  22. How do you set autocommit in an SQL Server session?
  23. How do you determine what SQL Tables have an identity column programmatically
  24. Ampersand (&) operator in a SQL Server WHERE Clause
  25. how to write number to word function in sql server [closed]
  26. Milliseconds wrong when converting from XML to SQL Server datetime
  27. Using GROUP BY with FIRST_VALUE and LAST_VALUE
  28. What are row, page and table locks? And when they are acquired?
  29. Bootstrapping SQL Express from WiX?
  30. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?

Leave a Comment