Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag 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 | 2,665 reads
   Items 1 to 1 of 1