SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%aranacak text%'
AND ROUTINE_TYPE='PROCEDURE'
veya
SELECT OBJECT_NAME(id)
FROM SYSCOMMENTS
WHERE [text] LIKE '%aranacak text%'
AND OBJECTPROPERTY(id, 'IsProcedure') = 1
GROUP BY OBJECT_NAME(id)
veya
SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
AND definition LIKE '%aranacak text%'
Kaynak: http://stackoverflow.com/questions/5079457/how-do-i-find-a-stored-procedure-containing-text
Hiç yorum yok :
Yorum Gönder