New Transact SQL Video Tutorial: RAISERROR and Substitution Parameters - How to Customize Your Error Messages (SQL Server 2000)

RAISERROR and Substitution Parameters - How to Customize Your Error Messages (SQL Server 2000) - view details

This video is part of our series on using custom error messages in SQL Server and shows you how to create dynamic error messages that are stored in sysmessages (sys.messages in SQL Server 2005).

Highlights from this video:

• sp_addmessage
• Storing messages in the master database
• Calling adhoc messages
• Substition parameters (%s, %d) and dynamic vs. static parameterization
• Architecture of error messages in SQL Server 2005 and 2000
• RAISERROR and severity levels
• SQL Server error message 50000
• How to pass scalar functions into RAISERROR (i.e. SUSER_SNAME(), USER_NAME(), DB_NAME())
• Using RAISERROR in stored procedures for custom error handling
• Using RAISERROR WITH LOG to log SQL Server errors to the Event Log in Windows

• Category: Stored Procedure Programming, Error Handling, and Passing Resultsets to the Client
• Skill Level: 200 (Beginner - Intermediate)
• Length: 11:46 (7.25MB)
• Applies to Versions: SQL Server 2000
• 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