Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    10

    Unanswered: Cross-database Dependency Check

    Is there anyway to check for cross-database dependencies?

    For example:
    I have a stored proc in the Pubs database that contains a query that references a table in the Northwind database (as well as reference a table in the Pubs database.) I'm having no problems finding the depencency for the Pubs table. I can't seem to find the dependency for the Northwind table.

    Any help would be appreciated.

    Thanks in advance.

    Scott

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    SQL Server 2000 only tracks objects in the current database within dbo.sysdepends.

    -PatP

Posting Permissions

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