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