December 1, 2017 at 9:00 am
is there a way to find cross database dependencies in 2005
December 1, 2017 at 9:08 am
myukas - Friday, December 1, 2017 9:00 AMis there a way to find cross database dependencies in 2005
Why start a new thread for this when you have this one: https://www.sqlservercentral.com/Forums/1910376/finding-cross-dependent-databases-in-2005#bm1910412?
All this does is fragment possible answers across multiple threads.
December 1, 2017 at 11:38 am
Okay, I think sys.sql_modules may exist in SQL Server 2005, you will have to verify. If it does, you may have to write some extensive code to identify 3-part named tables in the SQL code stored in the definition column and pull what you need from there.
Other than that, not sure there is much else you can do without having access to a SQL Server 2005 instance to do some actual research against.
December 1, 2017 at 11:41 am
thanks i have given up i realize there is no easy way to do this in 2005
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply