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

Custom Logging in a transaction Expand / Collapse
Author
Message
Posted Wednesday, July 21, 2010 11:19 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Today @ 7:04 AM
Points: 100, Visits: 570
Comments posted to this topic are about the item Custom Logging in a transaction
Post #956927
Posted Thursday, July 22, 2010 1:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, December 4, 2013 8:02 AM
Points: 330, Visits: 158
Nice idea.
I have used xp_cmdshell to pipe debug to logfile when transactions fail
declare @msg varchar(255)
set @msg = 'echo ' + 'debug text here' + ' > c:\log.txt'
exec xp_cmdshell @msg ,NO_OUTPUT

but this is better
Post #956963
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse