SQL SERVER 2005 - AVOIR LA LISTE DES PROCEDURES STOCKEES ET FONCTIONS D'UNE BASE

---------------------------------------------------------------
SELECT
	*
FROM sys.objects 
INNER JOIN sys.schemas 
	ON sys.schemas.schema_id = sys.objects.schema_id 
WHERE 
	sys.objects.type = 'P'		-- TYPE PROCEDURE STOCKEE
OR 
	sys.objects.type = 'FN'	-- TYPE FONCTION
ORDER BY 
	sys.objects.type, 
	sys.objects.name
---------------------------------------------------------------