Is it possible to log the RAISERROR messages into a table and not just to the Windows Even Log?
I've some stored procedures with the following line:
RAISERROR(@Message,10,1) WITH NOWAIT
and I'd like to have all this in a table without the need to modify it. So, the solution told by Steve about using a stored procedure like lsp_Debug couldn't be used.
Maybe in the way to execute it?