Home Forums SQL Server 2005 Administering Relationship information between tables situated at different databases RE: Relationship information between tables situated at different databases

  • January 13, 2014 at 5:25 am

    #1679544

    well, if there is a view or stored procedure that references a different database or a linked server, you can query for that.

    take a look at the view sys.sql_expression_dependencies, and pay attention to these columns:

    referenced_server_name

    referenced_database_name

    referenced_schema_name

    referenced_entity_name

    you may need to do that in each of your databases, since you are trying to discover dependancies,a dn they are "saved" local to each database.

    select *

    from sys.sql_expression_dependencies

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!