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 |
|
bmassey
Starting Member
22 Posts |
 Posted - 2008-03-17 : 16:32:24
|
| Anyone know of any tools that can be used to automate the tracking of DB object dependencies?We had a recent table change that was made for a front-end application update. The night the change was deployed several of our jobs failed as a result of the table change. Therefore, I'm looking for a tool that could be used to search through code (DTS, SQL, .Net, etc.) and document database dependencies. This would allow us to easily identify potential impacts of database changes. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-17 : 18:53:32
|
| sysdepends table is a start... it's a bit inaccurate in SS2k if i remember correctly _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
|
|
|
Tools to track database dependencies?