Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RaghaSM
Yak Posting Veteran
52 Posts |
 Posted - 2008-12-08 : 15:52:14
|
| Hi All,I have around 50 stored procs and want to check a table name "LogDetails" is used by any storedprocure or not and if so I want the list of al the stored procs that uses thi stable. Is there any command to get this details? please hel. very urgent.YOur help will be very much appreciated.Ragha |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-12-08 : 16:02:33
|
| select object_name(id), text from dbo.syscomments where text like '%create procedure%LogDetails%' |
 |
|
|
RaghaSM
Yak Posting Veteran
52 Posts |
Posted - 2008-12-08 : 16:21:57
|
| Thnak you very much. This helped |
|
|
|
|
|
|
VEry urgent---- please help