SQL SERVER | Ricercare un testo in tutte le stored procedure

21 marzo 2014 1 min di lettura Database Microsoft SQL Server Windows

SELECT o.Name AS ‘StoredProcedure’ FROM SysObjects AS o INNER JOIN SysComments AS c ON o.ID = c.ID WHERE c.\[Text\] LIKE ‘%testo da ricercare%’ AND o.\[Type\] = ‘P’

SELECT o.Name AS 'StoredProcedure'
FROM SysObjects AS o
INNER JOIN SysComments AS c ON o.ID = c.ID
WHERE c.[Text] LIKE '%testo da ricercare%'
AND o.[Type] = 'P'