Advertisement
Guest User

Untitled

a guest
Jan 18th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. CREATE SERVER AUDIT [AuditLogin]
  2. TO FILE
  3. ( FILEPATH = N'D:audit'
  4. ,MAXSIZE = 5 GB
  5. ,MAX_ROLLOVER_FILES = 2147483647
  6. ,RESERVE_DISK_SPACE = OFF
  7. )
  8. WITH
  9. ( QUEUE_DELAY = 1000
  10. ,ON_FAILURE = CONTINUE
  11. )
  12.  
  13. CREATE SERVER AUDIT SPECIFICATION [EveryLogin]
  14. FOR SERVER AUDIT [AuditLogin]
  15. ADD (FAILED_LOGIN_GROUP),
  16. ADD (SUCCESSFUL_LOGIN_GROUP),
  17. ADD (LOGOUT_GROUP)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement