Thursday, August 1, 2013

how to get complete list of user defined stored procedures on a particular DB

SELECT * FROM SYS.procedures WHERE NAME NOT LIKE 'SP_%DIAGRAM%' ORDER BY create_date desc

No comments:

Post a Comment