SELECT DISTINCT so.name FROM syscomments sc INNER JOIN sysobjects so ON sc.id=so.id
Please sign in to leave a comment.
Here is a simple code to find all ACTIVE Stored Procedures in SQL Server