We want our webservice to return only the descriptive message part of a Sql error to the client . As it stands, we get a SOAP error, along with all the baggage.

Our exact problem:

We want the Sql Server Error : Concurrent Limit Exceeded ,
to be exactly what we show when someone tries to login at a client app.

The webservice is of course wrapping into SOAP, and we need to devise a way to simply get that original error to display to the user.

Any suggestions?