>>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

Perfect!  Thank you!

Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people