Friday, February 17, 2012

Dependency Tools

All,
Looking for recomendations on a tool that can check to see
if a table is being used in that db, or by any other db on
the same server. I have several db's on the same server
and sometimes a proc in another db needs a particular
table to be there.
Thanks in Advance,
Gary Abbott
Hi Gary,
Why not try
AGS SQL Scribe Documentation Builder. It produces HTMLHelp based
documentation which can then be searched. This way you are guaranteed to
find all objects that use the table.
http://www.ag-software.com/ags_scribe_index.aspx
Kind regards
Greg Obleshchuk
Partner
A & G Software
http://www.ag-software.com
"Gary Abbott" <anonymous@.discussions.microsoft.com> wrote in message
news:138001c4265a$b9e34d10$a101280a@.phx.gbl...
> All,
> Looking for recomendations on a tool that can check to see
> if a table is being used in that db, or by any other db on
> the same server. I have several db's on the same server
> and sometimes a proc in another db needs a particular
> table to be there.
> Thanks in Advance,
> Gary Abbott

No comments:

Post a Comment