getting list of parameters of a stored procedure in sql server 2005

[I Never Look Behind]

Hi! there is a stored procedure containing 3 input parameter & 2 output parameters. now i want to write a sql query that lists parameters as well as their parameter types & data type for a particular sotred procedure. can any help me in this regards?

[N a v a n e e t h]

SELECT * FROM INFORMATION_SCHEMA.PARAMETERS

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia My Website | Ask smart questions

[I Never Look Behind]

Thanks!!!