spStaticNoStopOnFirstError will not continue as the table it refers to does not exist.

However an sp will continue after a unique/primary key violation.

The problem I have is that Key violations do not terminate the current batch (unless XACT_ABORT IS set) But ADO does put a client application in the error handler.

My...

Nice article. On a related note do you have any ideas on how to detect whether a stored procedure completed execution when run from ADO?

For instance take the following SQL;

CREATE...