PrepAway - Latest Free Exam Questions & Answers

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

PrepAway - Latest Free Exam Questions & Answers

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.

2 Comments on “Which system stored procedures should you use?


Leave a Reply