I have an old server running SQL Server 2000.
I need to perform some maintenance on the server and one step is to check for dependencies on other servers.
The SQL Server 2000 machine has database A, while database B is running on a different server. DB A has stored procedures that will modify some table fields on DB B and vice-versa. I want to know what cross DB/Server references there are, what should I do?
Best Answer
I'm fairly sure that there isn't a reliable way to do this. I remember being very surprised when I dropped and recreated a table in SQL Server 2000 and lost all the dependencies to the stored procedures that refer to it.
You can try looking at sysremotelogins and sysservers, but I doubt that will cover the full list.