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 |
|
drpkrupa
Yak Posting Veteran
74 Posts |
 Posted - 2007-03-19 : 16:30:39
|
| I have a database with couple of store procedure and views.Is there any way that i can find out all sp or views which contains word like *svc*. I am talking about the containt of the sp and views not name. We are replacing one module so i have to change the all sp and views which use table or view start with svc.Need help.Thanks |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-19 : 16:32:49
|
| Yes.The fast way is to script complete SPs out to query window and do a search there.Peter LarssonHelsingborg, Sweden |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-03-19 : 16:35:49
|
you can also do this:select * from syscomments where text like '%svc%'
www.elsasoft.org |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-03-19 : 16:40:12
|
| Check out if this script works for you. i have written it quite a long back though... http://chirikworld.blogspot.com/2006/10/when-we-are-working-with-lots-of.html#linksChiraghttp://chirikworld.blogspot.com/ |
|
|
|
|
|
|
Query analyzer help