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 |
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
 Posted - 2007-04-21 : 23:42:53
|
| I for some reason can not get a accurate list of my depedencies for a stored procedure.Is there a way to refesh All Table and Procedure dependencies.I have stored procedures that I can open and view that the procedure updates specific tables, but these tables do not show that procedure as a dependency (I know it did at one point in time though).Maybe the dependency list is not supposed to work like that, but can someone please clearify or point me in the correct direction.Thanks. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-22 : 14:02:55
|
broken dependency chains in sysdepends is the most likely reason. if you ALTER your proc with no changes to the actual code of the proc, it should fix up sysdepends in 2005. this trick doesn't work in 2000 though.
www.elsasoft.org |
 |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2007-04-22 : 21:10:50
|
| I tried that and still no luck. The DB was a sql2000 db then it was detached and added to my instance of sql2005. Is there something else I should've done? |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-23 : 01:26:55
|
maybe try backup 2000 and restore to 2005?just to make sure it is a broken chain in sysdepends, you might try this query and look for the dependency:select so2.name as parent so1.name as dependentfrom sysdepends djoin sys.objects so1 on d.id=so1.object_idjoin sys.objects so2 on d.depid=so2.object_idwhere so1.name='your proc name'
www.elsasoft.org |
|
|
|
|
|
|
Refesh Dependencies