I've started work as an SQL Server DBA.. there's a lot to learn, so i've created this blog to help me add generic examples I gain along the way, so I don't forget them.
Thursday, 24 March 2011
Find text in Stored Procedures
The following query returns all delete stored procedures with a delete clause;
SELECT
*
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_TYPE = 'PROCEDURE'
AND ROUTINE_DEFINITION LIKE '%DELETE%'
No comments:
Post a Comment