Afternoon,
Essentially I want to increment an error counter each time an error is encountered executing a stored procedure. So for example.....
..... will catch the return status from the procedure. What I would like to do is this following which of course is illegal.
Can anyone suggest a neat method for doing this?
Regards,
TheGeezza
Essentially I want to increment an error counter each time an error is encountered executing a stored procedure. So for example.....
Code:
exec @custom_error = sp_executesql @sql
Code:
exec @custom_error = @custom_error + (sp_executesql @sql)
Regards,
TheGeezza