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

  Discussion forum


Leave an answer