SQL Server:

I am calling stored procedures from VB using ADO 2.6

I have error handling in my stored procedures but it doesn't seem to do anything as any error in the procedure generates an RT error in VB.

I don't want this to happen as I want to stored procedure to deal with any errors that occur.

Does anybody know what I am not doing?

Simon.