ALTER SERVER AUDIT |
Modifie l'audit serveur |
|---|---|
| SQL Server 2012+ | Microsoft SQL Server |
Syntaxe
|
ALTER SERVER AUDIT audit_name { [ TO { { FILE ( file_options [, ...n] ) } | APPLICATION_LOG | SECURITY_LOG } | URL] [ WITH ( audit_options [ , ...n] ) ] [ WHERE predicate_expression ] } | REMOVE WHERE | MODIFY NAME = new_audit_name [ ; ] file_options::= { FILEPATH = 'os_file_path' | MAXSIZE = { max_size { MB | GB | TB } | UNLIMITED } | MAX_ROLLOVER_FILES = { integer | UNLIMITED } | MAX_FILES = integer | RESERVE_DISK_SPACE = { ON | OFF } } audit_options::= { QUEUE_DELAY = integer | ON_FAILURE = { CONTINUE | SHUTDOWN | FAIL_OPERATION } | STATE = = { ON | OFF } } predicate_expression::= { [NOT ] predicate_factor [ { AND | OR } [NOT ] { predicate_factor } ] [,...n ] } predicate_factor::= event_field_name { = | < > | ! = | > | > = | < | < = } { number | ' string ' } |
Description
Cette instruction permet de modifier un objet de journal de bord du serveur utilisé par le SQL Server Audit.
Dernière mise à jour : Vendredi, le 19 Juin 2020