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 3, 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 3, 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 3, 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: Tuesday, September 23, 2014 6:00 AM
Points: 3,478, Visits: 1,074
returns the error severity specific to the scope of the CATCH block in which it is referenced


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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:27 PM
Points: 13,776, Visits: 28,178
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 Query Performance Tuning
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