Getting Database Error Number

[Guest]

H
Does anyone know how to pass back the specific database error number from a SQL Server stored procedure, or else how the exception can beused to get this - I want to detect error 547 (foreign key violation) and display a more user friendly error message to the user but when the codes goes into the catch, all I can get from the exception is the full verbose error message ("DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_tblJob_tblClient'. The conflict occurred in database 'NIIR', table 'tblJob', column 'ClientID'
The statement has been terminated."

Many thank
Siobhan

 

[William Ryan eMVP]

Siobhan:

You can use InfoMessage to trap errors with a severity < 10
http://www.knowdotnet.com/articles/connections.html . I believe the Message
property of the sqlException's Errors Collection will give you the info your
need for exceptions with higher severity number).

HTH,

Bill

Hi
Does anyone know how to pass back the specific database error number from

a SQL Server stored procedure, or else how the exception can beused to get
this - I want to detect error 547 (foreign key violation) and display a more
user friendly error message to the user but when the codes goes into the
catch, all I can get from the exception is the full verbose error message
("DELETE statement conflicted with COLUMN REFERENCE constraint
'FK_tblJob_tblClient'. The conflict occurred in database 'NIIR', table
'tblJob', column 'ClientID'.