Microsoft Techies: stored procedures

Showing posts with label stored procedures. Show all posts

Tuesday, 13 May 2014

To get all stored procedures

exec sp_stored_procedures

DatabaseName.dbo.sp_stored_procedures

DatabaseName.dbo.sp_helptext StoredProcedureName

to get all information
SELECT * FROM sys.objects;

SQL Server 2005 To get all stored procedures

SELECT * FROM sys.procedures;