>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 ?

Hi Pete,

Take a look here
How to insert information into multiple related tables - shows usage of raiserror and try/catch

and
How to return error messages from the SQL Server to the client using SQLDataSource

shows how to consume these error messages raised by RAISERROR