logins usage

  • Hi all,

    i'd like to know if there is the possibility to check logins usage cause i have to administrate a sql server with a lot of sql logins but i'm not sure that these logins are currently used.

    thx

    Filippo

     

  • run a profiler trace and collect the login success event.

  • In Enterprise Manager, right click on the instance, select Properties. Go to the Security tab. You should see a section for Auditing. Check the box for successful logins.

    -SQLBill

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply