You administer a database named Contoso running on a Microsoft SQL Server 2008 R2 instance.
You plan to implement custom error handling in your application. You need to implement custom error handling that meets the following requirements:
•The custom message is a reusable user-defined error message.
•The message returned to the application is an informational message that returns status information or error that is not severe.
•The custom message returned indicates that an error has occurred in the current database and current session.
Which three Transact-SQL statements should you use? (To answer, move the appropriate statements from the list of statements to the answer area and arrange them in the correct order.)
Build List and Reorder:
