Code to find all Stored Procedures in SQL Server

Share your SQL code snippets for SQL Prompt!

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Code to find all Stored Procedures in SQL Server

Postby paulxavierx » Fri Jun 03, 2011 7:19 pm

Hi,
Here is a simple code to find all ACTIVE Stored Procedures in SQL Server


Code: Select all
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
paulxavierx
 
Posts: 1
Joined: Fri Jun 03, 2011 7:06 pm

Return to SQL Prompt code snippets

Who is online

Users browsing this forum: No registered users and 0 guests