Discovering SQL Server Object Dependencies

Apart from it being one of the features advertised by TOAD, where else
might I be able to find tools for displaying the dependencies between
objects. A node-based viewer (eg tree control) would be ideal. Does
any such tool exist?Hi Kofi
http://www.ag-software.com is one option.
Regards,
Greg Linwood
SQL Server MVP
"Kofi" <kofisarfo@.gmail.com> wrote in message
news:5c157557.0405130109.12ccc481@.posting.google.com...
> Apart from it being one of the features advertised by TOAD, where else
> might I be able to find tools for displaying the dependencies between
> objects. A node-based viewer (eg tree control) would be ideal. Does
> any such tool exist?

Discovering SQL Server Object Dependencies

Apart from it being one of the features advertised by TOAD, where else
might I be able to find tools for displaying the dependencies between
objects. A node-based viewer (eg tree control) would be ideal. Does
any such tool exist?
Hi Kofi
http://www.ag-software.com is one option.
Regards,
Greg Linwood
SQL Server MVP
"Kofi" <kofisarfo@.gmail.com> wrote in message
news:5c157557.0405130109.12ccc481@.posting.google.c om...
> Apart from it being one of the features advertised by TOAD, where else
> might I be able to find tools for displaying the dependencies between
> objects. A node-based viewer (eg tree control) would be ideal. Does
> any such tool exist?

Discovering SQL Server Object Dependencies

Apart from it being one of the features advertised by TOAD, where else
might I be able to find tools for displaying the dependencies between
objects. A node-based viewer (eg tree control) would be ideal. Does
any such tool exist?Hi Kofi
http://www.ag-software.com is one option.
Regards,
Greg Linwood
SQL Server MVP
"Kofi" <kofisarfo@.gmail.com> wrote in message
news:5c157557.0405130109.12ccc481@.posting.google.com...
> Apart from it being one of the features advertised by TOAD, where else
> might I be able to find tools for displaying the dependencies between
> objects. A node-based viewer (eg tree control) would be ideal. Does
> any such tool exist?

Discovering SQL databases

Hi, I'm in the process of migrating / decommissioning a series of SQL
servers.
Is there / are there any tools to sniff out any existing eroneous SQL
databases which people may have created by themselves?
TIAThere are several ways to accomplish the task. Here are a couple ideas.
User SQLPing. Read about its usage here:
http://www.sqlteam.com/item.asp?ItemID=5403
A simple bat file idea:
http://www.databasejournal.com/feat...cle.php/3397981
And of course, any decent network scanning tool.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Stu" <lbwer@.blah.com> wrote in message
news:uzQExf$rGHA.2464@.TK2MSFTNGP03.phx.gbl...
> Hi, I'm in the process of migrating / decommissioning a series of SQL
> servers.
> Is there / are there any tools to sniff out any existing eroneous SQL
> databases which people may have created by themselves?
> TIA
>|||I suspect you mean sniff out instances of SQL Server, not databases.
I use SQL Recon: http://www.specialopssecurity.com/labs/sqlrecon/
Great utility to find any instance running on the network.
"Stu" <lbwer@.blah.com> wrote in message
news:uzQExf$rGHA.2464@.TK2MSFTNGP03.phx.gbl...
> Hi, I'm in the process of migrating / decommissioning a series of SQL
> servers.
> Is there / are there any tools to sniff out any existing eroneous SQL
> databases which people may have created by themselves?
> TIA
>sql