안녕하세요 sp실행중에 lock 발생하는데 lock 다른 sp가 아니라 ssms에서 나는데 이유를 모르겠습니다
lock 관련 정보
프로그램 : MicrosoftSQLServerManagementStudio-Transact-
wait sp :
SELECT
tr.name AS [Name],
tr.object_id AS [ID],
CAST( tr.is_ms_shipped AS bit) AS [IsSystemObject],
CASE WHEN tr.type = N'TR'THEN 1 WHEN tr.type =N'TA' THEN 2 ELSE 1 END AS [ImplementationType],
CAST ( CASE WHEN ISNULL(smtr.definition , ssmtr.definition ) IS NULL THEN 1 ELSE 0 END AS bit) AS [IsEncrypted]
FROM sys.triggers AS tr
LEFT OUTER JOIN sys.sql_modules AS smtr ON smtr.object_id=tr.object_id
LEFT OUTER JOIN sys.system_sql_modules AS ssmtr ON ssmtr.object_id=tr.object_id
WHERE (tr.parent_class=0)
ORDER BY [Name] ASC
내용이 부족하면 말씀해주세요 최대한 내용 찾아보겠습니다.
