Exclude a sql-statement in an DTS transaction

• Johan Carleson

  Grasshopper

  Points: 17

  More actions

  December 22, 2004 at 6:33 am

  #60579

  Hi !

  Is there anyway to exclude a sql-statement that is included in a DTS transcation block.

  My problem is that i got a logging table that i use in my stored procedures. But every time there is a rollback, the current log entries will just be wiped-out.

  I guess that logging to the msdb tables (sysdtstasklog)

  also will result into a rollback, or am i wrong ?

  Regards.

  Johan

  regards.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 739030

  More actions

  December 27, 2004 at 8:29 am

  #535045

  You can log a limited amount to disk. Not sure there's a good way to do this.