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.
B & D ???
I think B and D correct answer…
B & D should be correct answer.
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-operator-transact-sql
https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-alert-transact-sql