You are the SQL administrator for your company. You install a new instance of SQL Server 2008 on a servernamed SQL1 . SQL1 contains a database named SalesDB that is accessed by all users on the network. You are in the process of creating an alert using the sp_add_alert system stored procedure that will be triggered when the number of deadlocks for the SalesDB database exceeds two. You want to ensure that you receive anotification message through e-mail that includes the description of the error.
How should you configure the @include_event_description_in parameter?
A.
Specify a value of 0.
B.
Specify a value of 1.
C.
Specify a value of 2.
D.
Specify a value of 4.
Explanation:
You should specify a value of 1 for the @include_event_description_in parameter. An alert is an automatedresponse to an event or performance condition, which is triggered when a particular event or performancecondition occurs. You can use SQL Server Management Studio, the sp_add_alert system stored procedure, or System Monitor to create a new alert. While configuring an alert, you can also specify how the alert shouldrespond to an event. You can configure an alert to execute a job or notify operators when a particular event isoccurred. The notification can be sent through via e-mail, a net send message, or a pager message. The @include_event_description_in parameter can be used if you want to include the description of the errormessage in the notification. Specifying a value of 1 for the @include_event_description_in parameter indicatesthat the description of the error should be included in the notification. To complete the requirements in thisscenario, you would also use the sp_add_notification system stored procedure passing a value of 1 for the @notification_method parameter to create an e-mail notification. You should not specify a value of 0 for the @include_event_description_in parameter because this valueindicates that the description of the error message should not be included in the notification message. You should not specify a value of 2 for the @include_event_description_in parameter because this value isused to include the description of the error message in a pager message. You should not specify a value of 4 for the @include_event_description_in parameter because this value isused to include the description of the error message in a net send message.
Objective:
Maintaining SQL Server InstancesSub-Objective:
Manage SQL Server Agent alerts.References:
MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Technical Reference > Transact-SQLReference > System Stored Procedures (Transact-SQL) > SQL Server Agent Stored Procedures (Transact-SQL)> sp_add_alert (Transact-SQL) MSDN > MSDN Library > Servers and Enterprise Development > SQL Server > SQL Server 2008 > ProductDocumentation > SQL Server 2008 Books Online > Database Engine > Operations > Performance >Performance Monitoring and Tuning How-to Topics > Server Performance and Activity Monitoring How-to Topics> How to: Set Up a SQL Server Database Alert (Windows)