SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by deepforest / Custom Logging in a transaction / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 13:29:28 GMT20RE: Custom Logging in a transactionhttp://www.sqlservercentral.com/Forums/Topic956927-1701-1.aspxNice idea. I have used xp_cmdshell to pipe debug to logfile when transactions fail[code="sql"]declare @msg varchar(255)set @msg = 'echo ' + 'debug text here' + ' &gt; c:\log.txt'exec xp_cmdshell @msg ,NO_OUTPUT [/code]but this is betterThu, 22 Jul 2010 01:15:55 GMTFiacre LenehanCustom Logging in a transactionhttp://www.sqlservercentral.com/Forums/Topic956927-1701-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Custom+Logging/70637/">Custom Logging in a transaction</A>[/B]Wed, 21 Jul 2010 23:19:08 GMTdeepforest