Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Thursday, October 23, 2008 9:31 AM


Group: General Forum Members
Last Login: Friday, November 18, 2016 7:45 AM
Points: 140, Visits: 4,665

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:
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



Group: General Forum Members
Last Login: Today @ 3:23 PM
Points: 42,036, Visits: 39,415
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."

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