Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Error Trapping

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-01-25 : 09:12:17
Mala writes "Hi,

Please let me know how can I trap a SQL error in a procedure and avoid SQL to display its ins built message. I mean if any referential constraint is there on the table which I am trying to delete and intern the child table has got records, I want to trap SQL error and raise my own error number.

Thanks in advance.

Bye,
Mala"

Nazim
A custom title

1408 Posts

Posted - 2002-01-26 : 00:21:56
Check for RAISERROR in BOL , it should help you.


--------------------------------------------------------------
Dont Tell God how big your Problem is , Tell the Problem how Big your God is
Go to Top of Page
   

- Advertisement -