Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Da_Retina
Posting Yak Master
109 Posts |
 Posted - 2002-03-05 : 04:56:01
|
| Salute..Does RAISERROR return from a stored procedure ?..I mean depending on the severity level or so?..or should I explicitly RETURN???Salute..------------------If I am to do it,I will, and NOW .. |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-03-05 : 09:41:53
|
| Actually RAISERROR will never return from a stored procedure. If severity of the error you are trying to raise is less than 20, the processing will continue (unless you follow RAISERROR statement with an explicit RETURN). If severity is 20 or higher (and you'd have to use WITH LOG option in such case) SQL Server will terminate connection. |
 |
|
|
|
|
|
RAISERROR