DECLARE @Trigger_Name VARCHAR(MAX) = 'TSMGO05L';
SELECT *
FROM (
SELECT
db_name() AS db_name,
tbl.name AS tbl_name,
tr.name AS tr_name,
ISNULL(smtr.definition, ssmtr.definition) AS [Definition]
FROM
sys.tables AS tbl
INNER JOIN sys.objects AS tr ON (tr.type in ('TR', 'TA')) AND (tr.parent_object_id=tbl.object_id)
LEFT OUTER JOIN sys.assembly_modules AS mod ON mod.object_id = tr.object_id
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
) AS A
WHERE Definition like '%'+ @Trigger_Name +'%'
'DataBase > MSSQL' 카테고리의 다른 글
작업스케줄한눈에보기 (0) | 2023.10.05 |
---|---|
특수문자 제거 함수 (1) | 2023.10.05 |
프로시저 실행 결과를 txt 파일로 저장하기 (0) | 2023.10.05 |
프로시져수정및생성일자확인 (0) | 2023.10.05 |
프로시져해당문구찾기 (1) | 2023.10.05 |