Get Stored Procedures parameter names and types...

Sorry if I haven't choose appropriate forum for this question.

I have MSSQL05 beta. I know how to list all stored procedures in selected database (everything is in localhost). I need to list parameter names and types for selected stored procedure(s).
How can I do that or anything that can return parameter names and types?

It's windows application.
You should move to a non-beta version as you are breaking the EULA with using the old version, but anyway, the parameters can be views with the

INFORMATION_SCHEMA.Parameters

view.

SELECT *
FROM INFORMATION_SCHEMA.Parameters

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de
|||I will move to non-beta.

Thanks for the reply. This is what I wanted.