Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Location
    India,Mumbai
    Posts
    34

    Unanswered: Identify dependencies

    How Can I come to know the dependent database object of one database to another database.
    For Example: table t1 is in ‘employee’ database having insert trigger in table t1 is using another database ‘finance’. So in one glance how will I come to know that ‘finance’ database is dependent on employee database.

  2. #2
    Join Date
    Feb 2012
    Posts
    133
    is it sp_depends accomplished this.

  3. #3
    Join Date
    Feb 2012
    Location
    India,Mumbai
    Posts
    34
    sp_depends <DB object>
    will return me the dependent objects of that particular Database.
    However I need to get dependent object from other Database.
    Any Idea folks....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •