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 |
|
lw1990
Yak Posting Veteran
85 Posts |
 Posted - 2009-02-16 : 12:43:30
|
| I'm trying to upgrade my center database from SQL Server 2000 to SQL Server 2008. This database in the sever is very important and has core data in there, like HR data. We have many other databases in other servers setup a lot of Views, Stored Procedures to get data from this center database by using the statement like this example: Select * from CenterServer.HR_db.dbo.EmployeeInfo Now, if I upgrade this database and change the server name, database name, definitely all those Views, Stored Procedures in other servers will stop working. So, I’m trying to find all the Views, SPs in all servers, DBs and update them, but if I use the Find Dependencies in All Tasks of this DB, I only can find the dependencies in this (local) database. Does anybody has the same situation and figure out a better way to find all the dependencies in all other servers, DBs, not go to each View and SPs in each DBs of each server to find which of them using the “CenterServer.HR_db.dbo.EmployeeInfo”?Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-16 : 12:47:57
|
| You will need third-party tools like this:http://www.red-gate.com/products/SQL_Dependency_Tracker/index.htm |
 |
|
|
|
|
|
|
|
How to find all dependencies in other servers