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 |
|
dewacorp.alliances
452 Posts |
 Posted - 2008-04-22 : 19:58:08
|
| Hi thereI am jumping someone else code that is including sql side of it as well as .net app source code. I am trying to modify one of the stored procedure and I would like to know how to within the sql to search any stored procedures that use this particular stored procedure (if it's any).We are talking about hundred stored procedure so I might miss to manual check this one by one.From the .net app point of view, it's is easy I guess by search the string for the entire solution.Thanks for your help. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-04-22 : 20:02:03
|
you could script out all objects to a file and then search the file.or run sqlspec and search the chm (see link below).
elsasoft.org |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-23 : 04:06:28
|
| http://sqlblogcasts.com/blogs/madhivanan/archive/2007/12/13/script-out-procedures-and-functions-part-2.aspxMadhivananFailing to plan is Planning to fail |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-04-28 : 07:31:59
|
| select object_name(c.id) from syscomments cjoin information_schema.routines r on object_name(c.id)=r.routine_namewhere text like '%nameofthe_sp%' and c.id<>object_id('nameofthe_sp')group by object_name(c.id)--I think, not tested...--------------------keeping it simple... |
|
|
|
|
|
|
Finding Out Dependancies (SQL2K)