We are currently using SQL Server 7 and I need an stored procedure that catches errors and record each error in a table. I will call this procedure in a delphi application using BDE. The error caused in a procedure doesn't have to raise in a client application, but catch by the stored procedure and record in a table. It's like using begin/exception/end in Oracle PL/SQL. Is this possible? What options do I have? Thanks.
(Excuse about my written english if isn't good).