Is there any way to display all of the stored procedures in a database?
+1 direct filter on the procedures.
George
2010-01-26 17:22:57
+2
A:
SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
AdaTheDev
2010-01-26 17:18:39
A:
here is other way:
SELECT name
FROM sys.objects
WHERE type = 'P'
sanjeev40084
2010-01-26 19:53:58