Custom Logging in a transaction

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Fiacre Lenehan Mr or Mrs. 500 Points: 584 More actions · Answer 1

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

SSC Guru

Points: 76202

May 18, 2016 at 1:13 pm

Thanks for the script.