Hi i have 20 databases and lots of logins and automated process running from other systems i have to find unused logins and delete them and when i run a profiler trace on a server, it shows the application and login group name but it doesnot show on which database i have to delete unused logins and even some data bases are no more used as the application is no more used so how do i find databases that are no more used how can i find database last used date and time or last time when the database was used for some activity please help me mail me at rakraj_neo@yahoo.co.in thank u rakraj_neo@yahoo.co.in
I don't see any option in SQL 2000... If you have any table with date column which inserts data regularly check it...if not you need to use SQL profiler... Also check the following... http://sqlblog.com/blogs/aaron_bert...when-was-my-database-table-last-accessed.aspx
thank for the reply it is very nice but i forgot to mention that i have a SQL Server 2000 at my hand and i want last accessed dates of databases and tables in that can u help me in this regard please Thanks in advance
I need to remove logins that are no more used that is which are not accessed for more than 3 months and delete databases that are not used for more that 3 months and i have to do this in sql server 2000 please help