I am performing audit of SQL Server Instances in our environment. I like to know how to find out the details of below. It applies to SQL Server version 2000, 2005 and 2008
How to find the SQL Server Instance Last used?
There are SQL Server Instances on stopped state.
How to find, when the user database last used?
It is to make judjement if the database is in use or can be dropped
How to find, when the login last used on SQL Server?It is to make decision of if the login is not in use for given period of time, to drop the login.
I would appreciate any inputs on this. As there 'n' number of servers on the environment, i have to automate this process.
Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]