How do I get the error information if f ex an insert fails? Well, I did it this way:
Declare @error_number int;
Declare @error_desc nvarchar(max);
set @error_number = @@error;
if @error_number <> 0
begin
set @error_desc = (select substring(description,1,60) from master.dbo.sysmessages where error = @error_number);
insert into my_log values ('This is where I log errors with error number, error description, a date, procedure name and where in the procedure');
end
Not that hard :)