USE < database_name >; GO SELECT SCHEMA_NAME ( schema_id ) AS schema_name , o . name AS object_name , o . type_desc , p . parameter_id , p . name AS parameter_name , TYPE_NAME ( p . user_type_id ) AS parameter_type , p . max_length , p . precision , p . scale , p . is_output FROM sys.objects AS o INNER JOIN sys.parameters AS p ON o . object_id = p . object_id WHERE object_id = OBJECT_ID ( '<schema_name.object_name>' ) ORDER BY schema_name , object_name , p . parameter_id ; GO...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/t-sql/archive/2007/12/10/2897.aspx