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 |
|
mydogdating
Starting Member
5 Posts |
 Posted - 2007-02-05 : 10:13:51
|
| Hi guysI have a table which I need to analyze, what jobs this is working with, what stored procedure is calling this table etc. Is there any built-in function to show me or anybody know how to do it? This is my new job, and there are hundreds of stored procedures and jobs, do i really have to go thru one by one?Please help. Michelle |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-05 : 10:17:10
|
| System procedure sp_depends can help you to some extent.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
mydogdating
Starting Member
5 Posts |
Posted - 2007-02-05 : 10:27:08
|
| That's working charming, thank you so much HarshMy another question is ^^, is therey any silimar funtion that I can do with local packages? I mean, is there any way to find which packages are using this table/specific stored procedures?Thanks. |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-05 : 10:32:44
|
| Unfortunately you can't find dependencies for the packages since package data is stored in binary format.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
Any built-in function to show table relationship?