Suche in Procedures

Suche nach Text in Procedures und Views.

Siehe http://stackoverflow.com/questions/14704105/search-text-in-stored-procedure-in-sql-server:

SELECT DISTINCT o.name AS Object_Name,o.type_desc,m.definition
FROM sys.sql_modules m 
INNER JOIN sys.objects o 
ON m.object_id=o.object_id
WHERE m.definition LIKE '%SUCHTEXT%'