>>Hi All, I'm playing around with Raiserror() and would like to display my own error message without all the other stuff i.e. sp name, line number etc..., is this possible ?
>
>You have to supply to the RAISERROR statement at least 3 parameters
>

>--RAISERROR (<message>, <severity>,<state>)
>RAISERROR ('My Message', 10,1)
>

Hi Sergey, that is exactly what I'm doing and see a MessageBox with five lines of information - Index #0 - 'The error' - LineNumber: 12 - Source: >NET.SqlClient Data Provider - Procedure: MySP. What I would like, is , to just see the message text without all the other stuff