I am using predefined user messages and RAISERROR to control any erroneous occurences in my SPs. This all works very well.
My problem is how do you get the msg number via an OLEDB provider using VB ??
Even using standard programming techniques we can only retrieve the HRESULT with matches - 'An Error Occurred'
Any ideas ?