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 |
|
cognos79
Posting Yak Master
241 Posts |
 Posted - 2007-09-04 : 15:13:17
|
| I do have a view "v_test". I want a sql query that lists all the dependent objects "stored procedures or any other object" that depends on this view. |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-04 : 15:13:42
|
| Try sp_depends although its not very reliable.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
cognos79
Posting Yak Master
241 Posts |
Posted - 2007-09-04 : 15:24:12
|
| thanks |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-04 : 16:44:54
|
| select * from syscomments where text like '%v_test%' ?or something like that...join with sysobjects to retrieve the object namesHTH--------------------keeping it simple... |
|
|
|
|
|
|
list dependent objects.