December 18, 2009 at 3:02 pm
Hi I have been assigned the responsibility of scouring our 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 servers 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 3:28 pm
Please don't double post
Post any responses to http://www.sqlservercentral.com/Forums/Topic836660-1292-1.aspx
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply