Which SQL elements should you include in the recommendation?

You have a SQL Server 2012 instance named SQL1. SQL1 creates error events in the Windows Application
event log. You need to recommend a solution that will run an application when SQL1 logs a specific error in the
Application log. Which SQL elements should you include in the recommendation? (Each correct answer
presents part of the solution. Choose all that apply.)

You have a SQL Server 2012 instance named SQL1. SQL1 creates error events in the Windows Application
event log. You need to recommend a solution that will run an application when SQL1 logs a specific error in the
Application log. Which SQL elements should you include in the recommendation? (Each correct answer
presents part of the solution. Choose all that apply.)

A.
A policy

B.
A trigger

C.
A maintenance plan

D.
A job

E.
An alert



Leave a Reply 0

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