Tuesday 13 May 2014

SQL stored procedures

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;