i would like to get the formatted text of an error IN the procedure where the error occurs...
we can check the number of the error, with the global variable @@error, throught which i can handle the non formatted text by finding it in sysmessages...
but how to get the final text, which is received by the client.
ex : error 530
what i can get : " Attempt to insert NULL value into column %d in work table (table id %ld); column does not allow NULLS. UPDATE fails."
what i want : " Attempt to insert NULL value into column [myColumn] in work table (table id [MyTable]); column does not allow NULLS. UPDATE fails."
no the errorLog doesn't contain all the errors, and specially not the errors i want to get (problems with duplicate keys, losts of connection, ...).
and i would have liked to get the error IN the stocked procedure, to be able to insert it in a table before leaving it.
but the more i think about it, the more my hopes flee away...