Friday, February 28, 2014

SQL - List All Stored Procedures

I needed to get a list of all of the Stored Proceduresin a database. This is the script that I used:

select ROUTINE_NAME as [Name], LAST_ALTERED as [Date Modified], ROUTINE_DEFINITION as Script
from information_schema.routines 
where routine_type = 'PROCEDURE'

No comments:

Post a Comment

Thank you for commenting!