Red Gate forums :: View topic - Track Table Depedancy if it was dropped and recreated.
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Track Table Depedancy if it was dropped and recreated.

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
sdoran



Joined: 25 Jan 2007
Posts: 9

PostPosted: Thu Jan 25, 2007 3:05 pm    Post subject: Track Table Depedancy if it was dropped and recreated. Reply with quote

We find that sql server's dependancy feature will not identify a dependancy between and stored procedure and a table if the table was dropped and recreated (using the same table name). Does this tool get around that issue?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6644

PostPosted: Sat Jan 27, 2007 12:03 pm    Post subject: Reply with quote

Hello,

Dependency Tracker is a much better tool in this respect. SQL Server tries to track object dependencies by updating its' sysdepends system table. This has a raft of known problems -- the worst being (at least in SQL 2000) that it only updates objects at create-time. If your schema changes a lot, you can forget about using sysdepends.

Dependency Tracker actually parses the creation SQL code and generates the dependencies at runtime rather than relying on potentially stale and inaccurate data in sysdepends.
Back to top
View user's profile Send private message
sdoran



Joined: 25 Jan 2007
Posts: 9

PostPosted: Mon Jan 29, 2007 2:52 pm    Post subject: Thanks Reply with quote

Sounds great! thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group