See if there's anything here that helps:
http://www.swynk.com/-Mike
>Hi,
>
>I have to do some documentation on one of our systems that has over 100 stored procedures (excluding the system SP's).
>
>I'd like to write a query that will give the the SP name, table dependencies, input/output parameters and datatypes.
>
>My question is this: Should I query the system tables directly or use the Information Schema Views? If anyone already has a query that generates results similiar to what I'm looking for - would it be possible to post the query you used?
>
>Thanks,
>
>Al