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
Al Williams
Anola MB, CANADA