Hi all

I'm posting this in here first because i have a temporary solution i use in SQL but not sure if the whole problem relates to SQL only:

I'm trying to return an error message you get from SQL to an asp/vb variable.

e.g.

If the statement executed is incorrect due to user input or server problems and something like this happens:

Code:
(0 row(s) affected)
+@error_text        <<-- I have some error handling
I want to return the whole lot to asp when it occurs, but I think the first line '(0 row(s)...' is creating problems with data types. My fix is to turn nocount on and just return the error text as a recordset, but out of curiosity - does anyone know if the whole message can be returned or whether its impossible?