By using a special value for the RAISERROR state parameter, you can force the termination of a complex script and prevent its execution in the wrong database….

Explore these great resources across Microsoft.com. Windows. All Windows downloads; Download Windows 8.1 … Office. All Office downloads; Download ……

Remarks. If a sysmessages error is used and the message was created using the format shown for msg_str, the supplied arguments (argument1, argument2, and so on) are ……

RAISERROR is a more powerful statement than PRINT for returning messages back to applications. RAISERROR can return messages in either of these forms:…

Generates an error message and initiates error processing for the session. RAISERROR can either reference a user-defined message stored in the sys.messages catalog ……

T-SQL scripts and stored procedures don’t produce their PRINT statements and RAISERROR output in a way that keeps you informed of the code’s progress. You ……

RAISERROR is used to return messages back to applications using the same format as a system error or warning message generated by the SQL Server Database Engine….

In addition to the exceptions that SQL Server itself throws, users can raise exceptions within T-SQL by using a function called RAISERROR….