Forcing a query timeout in SQL Server

by

run this and then try your insert…

select * from yourTable with (holdlock,tablockx)

here, you can lock it for 5 minutes:

BEGIN TRANSACTION

SELECT * FROM yourTable WITH (TABLOCKX, HOLDLOCK)

WHERE 0 = 1

WAITFOR DELAY '00:05'

ROLLBACK TRANSACTION

More Related Contents:

  1. Optimistic vs. Pessimistic locking
  2. Confused about UPDLOCK, HOLDLOCK
  3. Is it possible to set a timeout for a SQL query on Microsoft SQL Server?
  4. SQL Server, the misleading XLOCK & optimizations
  5. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  6. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  7. How to convert SQL Server’s timestamp column to datetime format
  8. Local and global temporary tables in SQL Server
  9. Multiple rows to one comma-separated value in Sql Server [duplicate]
  10. SQL Server add auto increment primary key to existing table
  11. SQL Server: Difference between PARTITION BY and GROUP BY
  12. How do you truncate all tables in a database using TSQL?
  13. EF5: Cannot attach the file ‘{0}’ as database ‘{1}’
  14. SQL Server: How to select all days in a date range even if no data exists for some days
  15. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  16. TSQL: How to convert local time to UTC? (SQL Server 2008)
  17. SQL Server datetime LIKE select?
  18. Transpose rows and columns with no aggregate
  19. How can I import an Excel file into SQL Server? [closed]
  20. Possible to set default schema from connection string?
  21. Stored Procedure and Permissions – Is EXECUTE enough?
  22. Best way to store time (hh:mm) in a database
  23. Using variable in SQL LIKE statement
  24. Stored procedure – return identity as output parameter or scalar
  25. Why does a parameterized query produces vastly slower query plan vs non-parameterized query
  26. SELECT INTO a table variable in T-SQL
  27. SQL Server: Filter output of sp_who2
  28. How can I insert binary file data into a binary SQL field using a simple insert statement?
  29. Table Valued Function Killing My Query Performance
  30. How to do Sql Server CE table update from another table

Leave a Comment