Code to find all Stored Procedures in SQL Server

paulxavierxpaulxavierx Posts: 2
edited June 3, 2011 2:19PM in SQL Prompt code snippets
Hi,
Here is a simple code to find all ACTIVE Stored Procedures in SQL Server

SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
· Share on Twitter
Sign In or Register to comment.