Audit failed/successful login LOG

• Nivs719

  SSC Veteran

  Points: 208

  More actions

  December 19, 2019 at 2:37 pm

  #3709123

  Hello everyone (:

  I have some Audit issue on SQL Server 2008R2 version, standard edition.

  I want to Audit failed and successful login, so to do that i'm right click on the instance --> Properties -> Security, and choose the option "Both failed and successful logins", and save(see attach file)

  The only problem is that he keep a lot of  successful events, and I just want to save the last month and that's it.

  How do i do it ?

  Thank's!

  Attachments:

  You must be logged in to view attached files.

• Jeff Moden

  SSC Guru

  Points: 1004406

  More actions

  December 19, 2019 at 4:00 pm

  #3709167

  Duplicate post.  Please... no posts here.  No need to split up possible answers.  Go to the first one in process at https://www.sqlservercentral.com/forums/topic/audit-failed-successful-login-log-4#post-3709164

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)