![]() Maximum files – the number of files kept in the system. When the maximum number is reached, the new files overwrite the oldest ones. Maximum rollover files – the number of files kept in the system. When set to 0, the process is synchronous Queue delay – sets the number of milliseconds before the audit information is processed into a target file. In the Create Audit dialog, specify the audit name, audit destination, and path. To create a SQL Server Audit object, expand the Security folder in Object Explorer.To configure the feature using SQL Server Management Studio: ![]() ![]() The SQL Server Audit feature can be set up using either T-SQL, or SQL Server Management Studio options USE AdventureWorks GO GRANT ALTER TO AuditConfiguration
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |