Turning SQL error message off???

[dobrios]

Hi,
I don't think it's possible, but I might be wrong. Is there a way to suppress SQL server (non fatal) error messages, so they don't propagate to client.

I'm building an VB app that will be scheduled on server.
I'm looping through 5-6 servers and do data transfers.
So, if there any SQL error, server error propagates through ADO to client and stops execution.

I need to be able to continue with next server

Any ideas?
Thanks in advance.

 

[MDXer]

Not sure but wouldn't it be easier to do error trapping in the vb code?

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[dobrios]

Thanks for the reply, MDXer.
I did most of the error handling on server side and as well as detailed error logging.
I was looking for a way to suppress non-fatal errors from SQL server, so I don't have to duplicate extensvie error handling on client app.