View cross references

• shayeb

  Newbie

  Points: 3

  More actions

  June 14, 2010 at 2:55 am

  #219961

  Dears

  I have a small problem which i hope that if you can help through the problem or a work around .

  Basically we have a database server MS SQL server 2008 hosting allot of databases , inside most of the databases there is a some views that reference other databases , what i need is to know

  which view is referencing what , is there a query or a built in function

  that can help me through ?

  Thank you in advance fro your help

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  June 14, 2010 at 6:20 am

  #1179802

  Red Gate has a LOT of DB tools, and Dependency Tracker is one of them.

  Free for 14 days.

  http://www.red-gate.com/products/SQL_Dependency_Tracker/index.htm?utm_source=google&utm_medium=cpc&utm_content=brand_aware&utm_campaign=sqldependencytracker&gclid=CKnulP7Hn6ICFSQ65QodIkl4xw

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg