SQL Server Performance

sql profiler to find unused logins???

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

  1. rakesh_dba New Member

    Hi
    please help me with the better way of using sql profiler to find unused logins
    please help me
    thanking you in advance

    rakesh_dba, Jun 11, 2008
    #2

  2. Greg Larsen New Member

    There really don't seem to be a good way to see when a user last used there login. One option might be to log successful login attempts then read the ERROR log. Be advised that this could cause large ERROR logs should lots of users login per minute.
    Greg Larsen, Jun 12, 2008
    #3

  3. rakesh_dba New Member

    Thanks
    and i need to fine last accessed date of a database in sql server 2000 how can i get that
    please help
    Thanks
    rakesh_dba, Jun 15, 2008
    #4

Share This Page