Hi Mike,
Thanks for the tip - that was the first place I looked - although I couldn't seem to find what I was looking for this time. (I have found a number of excellent, time saving scripts at that site in the past.) I'll try to roll my own and see what I can accomplish.
Al
>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
Al Williams
Anola MB, CANADA