What should you create?

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.
You need to be notified immediately when fatal errors occur on Server01.
What should you create?

You administer a Microsoft SQL Server 2012 database named Contoso on a server named Server01.
You need to be notified immediately when fatal errors occur on Server01.
What should you create?

A.
An Alert

B.
A Server Audit Specification

C.
An Extended Event session

D.
A Resource Pool

E.
A Policy

F.
A SQL Profiler Trace

G.
A Database Audit Specification

Explanation:
http://www.sqlskills.com/blogs/glenn/creating-sql-server-agent-alerts-for-critical-errors/

Show Hint

Leave a Reply 3

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

dbo

dbo

A

Reply

Rafael DBA

Rafael DBA

Why are you just copying the answer here? in every question..

Reply

nochillza

nochillza

I sometimes check the comments even before questions answer, because it tends to be more reliable.

Reply