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.
If the statement executed is incorrect due to user input or server problems and something like this happens:
(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?