Sql

Search

how to identify locked tables in sql server

SELECT
OBJECT_NAME(p.OBJECT_ID) AS TableName,
resource_type, resource_description
FROM
sys.dm_tran_locks l
JOIN sys.partitions p ON l.resource_associated_entity_id = p.hobt_id

Comment

get locked tables sql server

select  
    object_name(p.object_id) as TableName, 
    resource_type, resource_description
from
    sys.dm_tran_locks l
    join sys.partitions p on l.resource_associated_entity_id = p.hobt_id

Comment

PREVIOUS	NEXT

Code Example
Sql :: SQL Server lock table example
Sql :: function in plsql
Sql :: update and replace mysql
Sql :: remove space in sql server 2012
Sql :: create table split string function in sql server
Sql :: how to select one row in mysql
Sql :: sql left characters
Sql :: sql drop procedure
Sql :: sum query in sql
Sql :: select 2 rows in sql
Sql :: desc in sql
Sql :: oracle difference between two dates in years
Sql :: sql date format dd-mm-yyyy
Sql :: oracle temporary table
Sql :: ERROR 1046 (3D000): No database selected
Sql :: sqlalchemy update row
Sql :: sqlite3 import csv
Sql :: dual in db2
Sql :: with postgres
Sql :: datetime postgres typeorm
Sql :: postgres user permissions
Sql :: mysql count multiple columns in one query
Sql :: mssql datetime to date
Sql :: oracle convert run duration to number
Sql :: get the location of where postgres database is stored
Sql :: how to ascending order in sql
Sql :: postgresql full text search
Sql :: mysql dump with table query
Sql :: PL SQL VARRAY of records
Sql :: oracle concat datetime

Search

SQL

how to identify locked tables in sql server

get locked tables sql server

ADD CONTENT