Post reply

Object dependencies across databases?

  • November 15, 2010 at 7:08 am

    #147565

    Hello all,

    SQL Server has a very useful feature called "Object dependencies". Unfortunately our DWH is distributed among several databases. Is there a way to see also "Obejct depencies" accross multiple databases (without a 3rd party tool) ?

    Thanks!

  • November 15, 2010 at 7:13 am

    #1250719

    not without something keeping track of those references;

    object dependancies are limited to exist inside a database...that way if you backup and restore, everything your object referenced are together.

    because multiple databases could be deleted/changed seperately from each other, you can't have a direct object dependancy, say from db1.procedure1 tp some table in db2;

    db2 could be dropped or changed, and the procedure would stop working.

    I've done documentation like this with extended properties, so that i know (for example) that a view references some tables in another database. then an application reads the extended properties i wrote to document the external references.

    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!

  • November 16, 2010 at 3:52 pm

    #1251627

    Have you tried this http://www.mssqltips.com/tip.asp?tip=2086&home? I use this everyday, works like a charm. Create a cursor for the set of db's you are looking to monitor.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply