Discovering SQL databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stu - 25 Jul 2006 15:37 GMT

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

Reply to this Message

Arnie Rowland - 25 Jul 2006 16:13 GMT

There 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/features/mssql/article.php/3397981

And of course, any decent network scanning tool.

Signature

Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

> Hi, I'm in the process of migrating / decommissioning a series of SQL
> servers.
[quoted text clipped - 3 lines]
>
> TIA

Reply to this Message

A McGuire - 28 Jul 2006 15:04 GMT

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.

> Hi, I'm in the process of migrating / decommissioning a series of SQL
> servers.
[quoted text clipped - 3 lines]
>
> TIA

Reply to this Message