Audit failed/successful login LOG
-
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:
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!
-
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)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply