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

Glad to help - time to work on something else.