MSSQL - LOCK 조회 쿼리
SELECT DER.SESSION_ID , DER.COMMAND , CONVERT(VARCHAR(10),CONVERT(INT, DER.TOTAL_ELAPSED_TIME/1000)) + N'초' AS TOTAL_ELAPSED_TIME , ISNULL(DB.NAME,DER.DATABASE_ID) AS DATABASENAME , ISNULL(OBJECT_NAME(ST.OBJECTID, ST.DBID),'') AS OBJECTNAME , CASE WHEN ENCRYPTED = 1 THEN N'Encrypted Text' ELSE (SELECT TOP 1 SUBSTRING(ST.TEXT,STATEMENT_START_OFFSET / 2+1 , (( CASE WHEN STATEMENT_END_OFFSET = -1 T..
2022. 8. 16.