Developing Microsoft SQL Server Databases — Question 49

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.)

Answer options

Correct answer: B, C

Explanation

The correct procedures for migrating alerts and email notifications are sp_add_operator and sp_add_alert. sp_add_operator is used to create operators who can receive alerts, while sp_add_alert defines the alerts themselves. sp_syspolicy_create_job and sp_audit_write do not pertain to alert or notification migration.