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.
https://technet.microsoft.com/en-us/library/ms191482%28v=sql.105%29.aspx
B,D?
should be B,D
Every Q and A out there says this should be B and C. I thought it should be B and D as well. https://msdn.microsoft.com/en-us/library/ms189531.aspx