Getting Database Error Number

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Siobhan said:
Hi
Does anyone know how to pass back the specific database error number from
Click to expand...
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'.
 
Back
Top