suppose I have the follwoing error
raiserror 50000 'Error Message'
This is in a sproc. I use this sproc within others to essentially return the same data each time, i.e. web site, view stats, now invoice
In the web site and stats I need this error to be raised, however in the invoice I would like to automate it, so although their are errors, in this case it would be acceptable and I would not like it to stop my schedule. Is there any form of error handling where I can catch this error and disregard it?
raiserror 50000 'Error Message'
This is in a sproc. I use this sproc within others to essentially return the same data each time, i.e. web site, view stats, now invoice
In the web site and stats I need this error to be raised, however in the invoice I would like to automate it, so although their are errors, in this case it would be acceptable and I would not like it to stop my schedule. Is there any form of error handling where I can catch this error and disregard it?