Track Table Depedancy if it was dropped and recreated.

Visualizes SQL Server object dependencies.

Moderators: David Atkinson, Anu Deshpande

Track Table Depedancy if it was dropped and recreated.

Postby sdoran » Thu Jan 25, 2007 3:05 pm

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?
sdoran
 
Posts: 9
Joined: Thu Jan 25, 2007 3:01 pm

Postby Brian Donahue » Sat Jan 27, 2007 12:03 pm

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.
Brian Donahue
 
Posts: 6669
Joined: Mon Aug 23, 2004 10:48 am

Thanks

Postby sdoran » Mon Jan 29, 2007 2:52 pm

Sounds great! thanks
sdoran
 
Posts: 9
Joined: Thu Jan 25, 2007 3:01 pm


Return to SQL Dependency Tracker 2

Who is online

Users browsing this forum: No registered users and 0 guests