SQL Server Performance

remove unused logins ???

Discussion in 'Performance Tuning for DBAs' started by rakesh_dba, Jun 11, 2008.

  1. rakesh_dba New Member

    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

  2. MohammedU New Member

  3. rakesh_dba New Member

    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
  4. rakesh_dba New Member

    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


Share This Page