SELECT *
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%SearchText%'
OR
SELECT *
FROM sys.objects
WHERE
type = 'P'
and
OBJECT_DEFINITION(OBJECT_ID) LIKE '%SearchText%'
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%SearchText%'
OR
SELECT *
FROM sys.objects
WHERE
type = 'P'
and
OBJECT_DEFINITION(OBJECT_ID) LIKE '%SearchText%'
No comments:
Post a Comment