Login Auditing in SQL 2005

  • a) For Few of the logins on the prod servers ( SQL 2005 Enterprise) , the password enforce policy got enabled ( it was not enabled earlier) . My requirement is to track the users/logins who has done that.

    b) If i enable C2 Audting , will I be able to track such users in the future.

    Any help would be appreciated.

  • Do you want to find the logins with PW policy enabled or Do you want to find the logins who have enabled the PW policy for the logins or users?

    Thank You,

    Best regards,

    SQLBuddy.

  • I want to find the logins who have enabled the PW policy for the logins or users.

  • nikhil.verma (9/13/2010)


    I want to find the logins who have enabled the PW policy for the logins or users.

    That should be available in sql server log

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

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

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