PrepAway - Latest Free Exam Questions & Answers

Tag: sql server "include_event_description_in"

How should you configure the @include_event_description_in parameter?

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?