Show Stored Procedures

SELECT so.NAME
	,created
	,last_altered
	,specific_catalog
	,routine_definition
	,sql_data_access
FROM sys.objects so
LEFT OUTER JOIN information_schema.routines sr ON so.NAME = sr.specific_name
WHERE objectproperty(object_id, N'IsMSShipped') = 0
	AND objectproperty(object_id, N'IsProcedure') = 1
ORDER BY created DESC
	,NAME

SELECT *
FROM information_schema.routines
WHERE routine_type = 'PROCEDURE'
ORDER BY specific_name

SELECT *
FROM sys.objects
WHERE objectproperty(object_id, N'IsMSShipped') = 0
	AND objectproperty(object_id, N'IsProcedure') = 1