SQL Server’da Kilitlenmiş Tabloların Listelenmesi
Herkese merhaba,
Bu kısımda SQL Server’da kilitlenmiş tabloların listelenmesi kodları olacak.
SELECT STR(request_session_id, 4, 0) AS spid , CONVERT(VARCHAR(12), DB_NAME(resource_database_id)) AS db_name , CASE WHEN resource_database_id = DB_ID() AND resource_type = 'OBJECT' THEN CONVERT(CHAR(20), OBJECT_NAME(resource_associated_entity_id)) ELSE CONVERT(CHAR(20), resource_associated_entity_id) END AS object , CONVERT(VARCHAR(12), resource_type) AS resrc_type , CONVERT(VARCHAR(12), request_type) AS req_type , CONVERT(CHAR(1), request_mode) AS mode , CONVERT(VARCHAR(8), request_status) AS status FROM sys.dm_tran_locks ORDER BY request_session_id , 3 DESC
