I have a question about ASP and stored procedures (SQL Server).



In stored procedure, when I try to insert a duplicate record, the code 

breaks right there and the ASP displays the error message rather than the 

stored procedure executing IF @@ERROR <> 0 condition.

I dont think we have something like "on error resume next" in stored 

procedure. Do we?

But, when I put "on error resume next" in ASP script, the "If @@Error<>0" 

(in stored procedure) gets executed. But, right now I am in development 

stage and I dont want to use "on error resume next" as this statement will 

supress other errors (if any).



Any ideas as to how to go about this?



TIA