Steven Leong said..
Stored procedures in SQL Server report errors to client applications via the RAISERROR command.
RAISERROR doesn't change the flow of a procedure; it merely displays an error message, sets the @@ERROR
automatic variable, and optionally writes the message to the SQL Server error log and the NT
application event log.