You plan to migrate an instance of SQL Server 2008 to a new installation of SQL Server 2012.
You need to migrate alerts and e-mail notifications.
Which system stored procedures should you use? (Each correct answer presents part of the solution. Choose
all that apply.)
A.
sp_syspolicy_create_job
B.
sp_add_operator
C.
sp_audit_write
D.
sp_add_alert
Explanation:
B: sp_add_operator creates an operator (notification recipient) for use with alerts and jobs.
C: sp_audit_write adds a user-defined audit event to the USER_DEFINED_AUDIT_GROUP. If
USER_DEFINED_AUDIT_GROUP is not enabled, sp_audit_write is ignored.