<p>What query can return the names of all the stored procedures in a SQL Server database</p>

<p>If the query could exclude system stored procedures, that would be even more helpful.</p>

```
```
select *  
  from dbo.sysobjects
 where xtype = 'P'
   and status > 0
```
```