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 :: t sql dynamic top n query
Sql :: select into
Sql :: if null put 0 sql
Sql :: how to install mysql 8.0 windows service
Sql :: deleting database in sql
Sql :: sql top 3 for each group
Sql :: android sqlite database example
Sql :: mysql count unique in group statement
Sql :: change schema in sql server
Sql :: ms sql print more than 1 variable
Sql :: mysql GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Sql :: POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
Sql :: sql tabelle erstellen
Sql :: sql duplicate a table with data
Sql :: influxdb delete measurement based on date
Sql :: sql union operator
Sql :: how to create a table based on another table in mysql
Sql :: sql pivot
Sql :: android sqlite query join
Sql :: mysql find max value row
Sql :: sql server datetime
Sql :: mysql mediumtext
Sql :: fk in insert mysql
Sql :: sql unique
Sql :: timestamp sql
Sql :: enum in sql server
Sql :: mysql string split to array
Sql :: oracle cpu metric
Sql :: mysql workbench
Sql :: date datatype in livesql

Search

SQL

how to identify locked tables in sql server

get locked tables sql server

ADD CONTENT