Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Quick Hints for using the RAISERROR Command Expand / Collapse
Author
Message
Posted Thursday, October 23, 2008 9:31 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, September 15, 2014 5:31 AM
Points: 139, Visits: 4,617


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?








Post #590549
Posted Wednesday, February 15, 2012 12:51 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 11:18 PM
Points: 35,267, Visits: 31,759
Richard Moldwin (11/23/2005)
T-SQL programming involves a major loss of productivity, compared to any other modern language I know of.


I know it's a wicked old post but the comment above is just so very wrong. It's like anything else... you have to know how to use the tool correctly in order to be productive with it.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1252701
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse