SQL SERVER – 2008 – List of All Stored Procedure in Database

use AdventureWorksDW2008R2
GO
SELECT NAME FROM SYS.ALL_OBJECTS WHERE type=‘P’