Friday, September 6, 2013

Script to list out all User Stored Procedures in database

SELECT NAME
 ,type
FROM dbo.sysobjects
WHERE (type = 'P')
ORDER BY NAME

No comments:

Post a Comment