January 17, 2013 at 6:52 am
Good afternoon... I wonder if anyone can help me with something which, as is often the way, I thought might be simpler.
I need to provide a list of columns and their associated datatypes that are in tables referenced by a large number of stored procs. Sp_Depends seems to get me most of the way to where I need to be, but alas does not return dependencies where the table being joined to is in a different database.
Does anyone have a brilliant idea that I can use and then look like a hero? Many thanks.
J
January 17, 2013 at 8:21 am
this can get you started: it shows every dependency that is using a cross database reference:
select
OBJECT_NAME(referencing_id) As ViewName,
OBJECT_NAME(referenced_id) As ReferencedObject,*
from sys.sql_expression_dependencies
where referenced_database_name is not null
getting the column names from the remote server is going to require some dynamic sql to extract i think, since you cannot use a value in a table to use as part of joined object.
Lowell
January 21, 2013 at 4:03 am
Many thanks, greatly appreciated.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy