작성일 : 11-12-06 13:33
|
[MsSQL] 프로시저 전체검색 (텍스트 , TEXT)
|
 |
|
글쓴이 :
조형래
 조회 : 4,689
|
EXEC sp_MSForEachDB 'Use SPICUS;
SELECT DISTINCT DB_NAME() AS [DATABASE NAME], A.NAME
FROM dbo.SysObjects A JOIN dbo.SysComments B ON A.ID = B.ID
WHERE A.TYPE = ''P'' AND B.TEXT LIKE ''%3개월%''
ORDER BY A.NAME;'
EXEC sp_MSForEachDB 'Use SPICUS;
SELECT DISTINCT DB_NAME(), o.name FROM sys.sysobjects o
JOIN sys.all_sql_modules m ON o.id = m.object_id
WHERE o.type = ''P'' AND m.definition LIKE ''%xp_cmdshell%''
ORDER BY o.name;'
|
|
1069
