SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Auditing, sp_cycle_errorlog Rss

   Items 1 to 1 of 1   

Automate collection and saving of failed logins for SQL Server

I re-cycle my SQL Server log every night using sp_cycle_errorlog. However, before I do, I would like to capture all of the failed logins recorded. I have auditing turned on for failed logins, but I want to make sure that I capture those events into a table so I can report on. How can I do this?  Read more...
By Additional Articles 2009/05/28 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 3,027 reads
   Items 1 to 1 of 1