>Is it possible to return a list of the parameters for a SQL stored proc\?
>
>I have this
>
>SELECT Name FROM sys.procedures ORDER BY Name
>
>which returns the proc names. Now I want the param names foe a given proc.

Try

SELECT P.Name, syscolumns.Name, systypes.Name, syscolumns.length 
FROM syscolumns INNER JOIN systypes ON syscolumns.xtype = systypes.type 
INNER JOIN sys.procedures P on SysColumns.ID = P.Object_ID
order by P.Name

 If it's not broken, fix it until it is.


My Blog