July 23, 2002 at 8:09 am
Hi,
Some errors stop my stored procedure. And others just go on running when I catch them with the @@error-clause. Can someone tell me when SQL decides when he stops and when he goes on?
Has it anything to do with the state of an error?
regards,
Nico
July 23, 2002 at 4:33 pm
Has to do with the severity and the errors. Some cannot proceed with processing. Which errors are cuasing issues?
Steve Jones
July 23, 2002 at 4:42 pm
Books Online(SQL 2000): Search on "severity".
July 24, 2002 at 12:04 am
We have to load data from several tables in several other tables.
We do this cursor base because an error may not stop the loading.
The procedure just has to log this error.
Now we want to be sure that the loading never failes. Because this isn't possible, we want to know when SQL failes.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply