I could recommend to use:

select *
from sysobjects
where id in ( select id
from syscomments
where text like '%sp_%'
)
order by name

It is more flexible and you can order it by any criteria.

The only problem with it is that you have to know in what DB to look.

Thanks,
Yuriy

________________________________

From: Lee Hemmings [mailto:mssqldba-ezmlmshield-x8708668.[Email address protected]
Sent: Thu 10/27/05 4:52 AM
To: LazyDBA Discussion
Subject: Find a object



Morning,

I have a DB server which has couple of db on it.

But I'm trying to find a SP on the server, is there any way of doing
this ?

Regards Lee


This email and any attachments are confidential. They may contain privileged information and are intended for the named addressee(s) only. They must not be distributed without Perfect Information's consent. If you are not the intended recipient, please notify us immediately and do not disclose, distribute, or retain this email or any part of it. Unless expressly stated, opinions in this email are those of the individual sender, and not of Perfect Information. We believe but do not warrant that this e-mail and any attachments do not contain any form of virus. You must therefore take full responsibility for virus checking. Perfect Information reserves the right to monitor all email communications through their networks.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




MS Sql Server LazyDBA home page