Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error Serverity Expand / Collapse
Author
Message
Posted Monday, December 03, 2007 12:00 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, December 21, 2007 4:00 AM
Points: 46, Visits: 76
ERROR_SEVERITY()

What is met by severity can u plz explain me

Thans
Post #428594
Posted Monday, December 03, 2007 12:48 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, September 17, 2013 1:42 AM
Points: 890, Visits: 451
Hi,

maybe this will help:
http://technet.microsoft.com/en-us/library/ms178567.aspx

Regards,
Oana.
Post #428600
Posted Monday, December 03, 2007 1:07 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, September 30, 2013 2:09 AM
Points: 3,131, Visits: 1,058
returns the error severity specific to the scope of the CATCH block in which it is referenced


Post #428602
Posted Monday, December 03, 2007 7:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 3:51 AM
Points: 14,788, Visits: 27,264
It simply gives you an indication whether the error is informational, really important, fatal to a connection or fatal to the server. See the reference linked above for details.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #428717
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse