New SQL Server Video Tutorial: Part 2 - Using Event Alerts (Error Alerts) And RAISERROR for Custom Error Alerts

Part 2 - Using Event Alerts (Error Alerts) And RAISERROR for Custom Error Alerts - view details

Continued in this second video in the series, Scott will walk you through the process of adding event alerts, working with RAISERROR and how to customize/generate a new alert.

Highlights from this video:

• Running RAISERROR to show you a couple more things.
• Ad-hoc messages: Error message 50000
• Adding custom error messages
• Defining the response to a SQL Server event alert
• The importance of SQL Server Agent with alerts

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Automating SQL Server: SQL Server Agent, Jobs, Email, Alerts and Scheduling
• Skill Level: 300 (Intermediate)
• Length: 10:00 (10.0MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: alerts, DBA, management, SQL Agent, WMI, Error Handling, Performance