So I have a number of separate databases on my SQL 2005 Server.
I also have a number of Reports in SSRS.
Many of the stored procedures in the various databases reference tables, functions, and stored procedures in other databases on the same server.
How can I accomplish the effect of right clicking on a stored procedure for instance, clicking view dependencies, and having everything show up in that list, not just the items in that DB?
It is all stored in the database in one form or another, but I must be missing some crucial piece to integrating it all together.
Note: I did not design this system, just maintaining and modifying existing items. There are no schemas to speak of. SSRS will most likely move to a dedicated server at one point with other data warehousing functions, so the ability to span servers would be useful.
Thanks!
Matt
Mhmm, I think this is not possible unless you parse the procedue on your own. There are no entries for dependencies in the system tables created for non-db-local objects. Additionally you can′t use schemabinding for maintainance as schemabinding applies only to two part names.
HTH, Jens SUessmeyer.
http://www.sqlserver2005.de
|||Are there any third party tools that would combine all this information into an enterprise version of "view dependencies"?thanks|||
Hi,
Jens is correct. There is a lot of confusion about "sysdepends", so we've added a new section explaining SQL dependencies in a web refresh section of the BOL. Please read:
SQL Server 2005 Books Online
Understanding SQL Dependencies
New: 5 December 2005
http://msdn2.microsoft.com/en-us/library/ms345449.aspx
Re: " any third party tools" - A quick MSN search turned up
http://www.red-gate.com/products/sql_dependency_tracker/index.htm
which I have never used.
Regards
No comments:
Post a Comment