November 18, 2010 at 2:09 am
hello experts i have around 700 databases in my UAT server and soo many logins, i have strong feeling in thease DBs and logins most of them are unusable, but thing is that how wud i know unused DBs and logins to remove them.
pls help
thanks in advance
November 18, 2010 at 2:18 am
You can make use of the scripts mentioned in this article to find out when was the database last accessed.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 18, 2010 at 5:46 am
which version of sql server are using in your UAT server.
Is databases & Logins created by you (DBA)?
Are you using UAT server as Database Hosting server?
Ram
MSSQL DBA
November 18, 2010 at 7:31 am
i am using 2005
ya m a DBA and DBs and login created by me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply