How to find out what is locking my tables?

by

Take a look at the following system stored procedures, which you can run in SQLServer Management Studio (SSMS):

  • sp_who
  • sp_lock

Also, in SSMS, you can view locks and processes in different ways:

enter image description here

Different versions of SSMS put the activity monitor in different places. For example, SSMS 2008 and 2012 have it in the context menu when you right-click on a server node.

More Related Contents:

  1. Only inserting a row if it’s not already there
  2. Effect of NOLOCK hint in SELECT statements
  3. Calculating distance between two points (Latitude, Longitude)
  4. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  5. SQL Server – How to lock a table until a stored procedure finishes
  6. T-SQL split string based on delimiter
  7. WHERE Clause vs ON when using JOIN
  8. Counting DISTINCT over multiple columns
  9. Partition Function COUNT() OVER possible using DISTINCT
  10. CREATE TABLE IF NOT EXISTS equivalent in SQL Server [duplicate]
  11. Cannot use UPDATE with OUTPUT clause when a trigger is on the table
  12. CASE WHEN statement for ORDER BY clause
  13. How to get last 7 days data from current datetime to last 7 days in sql server
  14. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  15. Reference an alias elsewhere in the SELECT list
  16. Using IF ELSE statement based on Count to execute different Insert statements
  17. Passing dynamic order by in stored procedure
  18. Select SQL Server database size
  19. Check if table exists and if it doesn’t exist, create it in SQL Server 2008
  20. How do I find the data directory for a SQL Server instance?
  21. How to return default value from SQL query
  22. How to concatenate all columns in a select with SQL Server
  23. How to automatically generate unique id in SQL like UID12345678?
  24. Row Offset in SQL Server
  25. SQL Server recursive self join
  26. Real life example, when to use OUTER / CROSS APPLY in SQL
  27. How to get script of SQL Server data? [duplicate]
  28. Add unique constraint to combination of two columns
  29. What does a transaction around a single statement do?
  30. COALESCE Function in TSQL

Leave a Comment