Error Serverity

Question

Post reply

Error Serverity

Subu

Say Hey Kid

Points: 680
More actions
December 3, 2007 at 12:00 am

#201373

ERROR_SEVERITY()
What is met by severity can u plz explain me
Thans

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Oana Schuster SSCommitted Points: 1642 More actions · Answer 1

Hi,

maybe this will help:

http://technet.microsoft.com/en-us/library/ms178567.aspx

Regards,

Oana.

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 2

returns the error severity specific to the scope of the CATCH block in which it is referenced

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 3

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

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning