December 18, 2009 at 2:29 pm
Hi I have been assigned the responsibility of scouring or network looking for SQL Server databases, determining the owner and users. Is there a utility that will make my task any easier? I have full admin rights. Up until now, I have been opening each SQL Server and opening each database and determining who the owner is and who the users are. The problem is that for years anyone and everyone has been allowed to open a new database on the network. We have approx 200 serves so going one by one is beginning to become a monumental task. The majority of the SQL Servers are 2003.
Thanks!
M
December 18, 2009 at 2:59 pm
To find the Servers:
OSQL command line utility
or
SQLRecon
Once you know the servers, you will need to run scripts against each of them to determine databases and database owners.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 18, 2009 at 4:56 pm
These only work if UDP 1434 is open between servers. Lots of routers shut this down after the SQL Slammer worm.
The only way I know of for sure to find everything is to use some system management utilty, like SMS, to scan the services on all machines.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply