Returning SQL error to Application   

I've build an application in Vs2005. For the dataaccesslayer i've
create the dataset with the datasource tool. After that i build stored
procedures for doing actions on the database. Now i want to return the
error messages to my application.

It's possible to give the errornumber back to the application, but i
want also the error message to return F/E:

Msg 8114, Level 16, State 1, Procedure DeleteStopDefinition, Line 0
Error converting data type nvarchar to int.



How can i fix this?

date: Thu, 18 Oct 2007 14:36:10 -0000   author:   active T