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 0

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