Which system stored procedures should you use?

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

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.



Leave a Reply 3

Your email address will not be published. Required fields are marked *