No words wasted! Getting to the point about the work I do, the problems I deal with, and some links to posts about where I work.
Translate
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!