SQL Server - Create a Server Audit named [Audit-8] in your SQL Server. This audit should use a file target located in C:

[answerhappygod]

SQL Server -
Create a Server Auditnamed [Audit-8] in your SQL Server. Thisaudit should use a file target locatedin C:\COPServer\Audits and the targetmay consist of an unlimited number offiles, each file will be limited in size to 32MB. The audit should be configured such that, in caseit fails to log an operation, that operationwill fail. It should also be configured with a filterto log only operations for members beingadded to, or removed from, a serverrole dbcreator. Make sure the audit isenabled, then, execute the script. If no errors, save the scriptas Audit8.sql in the above same filelocation.