Is it possible to suppress the default error message when using `RAISERROR`?

By: USER1511
4 September 2025 Help 5 minutes
4.5
76 views 76 comments 4 shares

Question

Grade: Education Subject: Help
Is it possible to suppress the default error message when using `RAISERROR`?
Asked by:
76 Viewed 76 Answers

Answer (76)

Best Answer
(271)
Yes, setting the `ERRORSEVERITY` and `LASTSEVERITY` session variables can suppress the default error message. Before calling `RAISERROR`, set `SET ERRORSEVERITY TO 0;` and `SET LASTSEVERITY TO 0;`. This ensures that only the custom message from `RAISERROR` is displayed.
Answered on 4 September 2025

Related Articles

in șirul de numere 81,100,136,144,225 unul singur nu este pătrat perfect.care?​

79 views 79 comments

Tanggapan kebakran rumah karena arus listrik

45 views 45 comments

Are there any preventative measures I can take to avoid encountering the ESP-DIST-001 error in Fortnite on Nintendo Switch?

123 views 123 comments

All employees should be encouraged to

37 views 37 comments

textul piatra pitigoiului​

26 views 26 comments

What steps should I take if all standard troubleshooting for ESP-DIST-001 error fails on my Nintendo Switch Fortnite?

117 views 117 comments

Letak wilayah Indonesia..?

26 views 26 comments

Is the ESP-DIST-001 error unique to the Nintendo Switch, or can it appear on other platforms playing Fortnite?

110 views 110 comments

precizați denumirea artistuluicare cântă la:​

45 views 45 comments

Sederhanakan
24 per 42 =
55 per 65 =

46 views 46 comments

Which of the following is part of the professional support services area?

1) a teacher

2) a school secretary

3) a school principal

4) a school social worker

160 views 205 comments

Uneste obiectele din clasa ta cu punctele cardinare corespunzatoare:

-Catreda
-Tabla
-usa
-banca

plssssss

149 views 149 comments

Latar belakang pelaksanaan KMB dan pengakuan kedaulatan?

56 views 56 comments

Fungsi : R>R dan g : R>R dirumuskan dengan f(x) = 1/2x - 1 dan g(x) = 2x + 4 . Tentukan (gof)^-1(6)

105 views 105 comments

Comentati-mi si mie va rog urmatorul vers :

,,Este vorba de foc si cenusa,, - Copaci fara padure (Adrian Paunescu )

126 views 126 comments

When energy is used, ATP molecules convert to ADP molecules. This process is called _____.
dephosphorylation
phosphorylation
oxidation
diffusion

160 views 168 comments

In a classic carnival ride, patrons stand against the wall in a cylindrically shaped room. once the room gets spinning fast enough, the floor drops from the bottom of the room! friction between the walls of the room and the people on the ride make them the "stick" to the wall so they do not slide down. in one ride, the radius of the cylindrical room is r = 6.6 m and the room spins with a frequency of 22.1 revolutions per minute. 1) what is the speed of a person "stuck" to the wall?

160 views 486 comments

scrie cu cifre romane numerele:948,482,193,999,1456,2997,3599,2006

66 views 66 comments