Pages

Monday, January 3, 2011

Get List of procedure in SQL Server

Select so.name FROM syscolumns sc,master..systypes st,sysobjects so
WHERE sc.id in (select id from sysobjects where type ='P')
 AND so.type ='P'
 AND sc.id = so.id
 AND sc.type = st.type
GROUP BY so.name

No comments: