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.
ScottSQL Server 2000 only tracks objects in the current database within dbo.sysdepends.
-PatP
Sunday, February 19, 2012
Cross-database Dependency Check
Labels:
contains,
cross-database,
database,
dependenciesfor,
dependency,
examplei,
microsoft,
mysql,
oracle,
proc,
pubs,
query,
references,
server,
sql,
stored
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment