You administer a Microsoft SQL Server database named Contoso on a server named Server01. You need to write messages to the Application Log when users are added to or removed from a fixed server role in Server01. What should you create?

A. A Database Audit Specification
B. A Policy
C. An Alert
D. A SQL Profiler Trace
E. A Resource Pool
F. An Extended Event session
G. A Server Audit Specification

  Discussion forum


Leave an answer