>>>Does type = 'P' mean "stored procedure"?
>>>And, will the above script show ALL stored procedures in all the databases?
>>
>>Yes, 'P' means Procedure and yes all of them will be shown.
>>If you want you can filter desired SP in WHERE clause.
>
>Hi Boris,
>
>I didn't check but I'm pretty sure that sys.objects will only show information for the current database.
Yes.
O!!!!
I didn't read the question properly.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.