Stop (pause) a transaction or exclude tsql code

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  May 9, 2006 at 8:52 am

  #169503

  Hi,

  I have a long sql code with a transaction.

  Inside the transaction there is a statement DBCC operation.

  The problem is that into a Transaction is not possible to perform a DBCC operation.

  How can I do?

  Is there a way to stop (pause) the transaction and the resume it or exclude the piece of code from transaction ?

  Thank

  

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  May 9, 2006 at 9:39 am

  #636797

  I don't think so. You'll have to change your logic to move your DBCC statement out of the transaction somehow.

  ---

• Todd Stu

  Say Hey Kid

  Points: 690

  More actions

  May 10, 2006 at 11:02 am

  #637057

  what is the dbcc, maybe write an sp that duplicates the dbcc function?

  ---

  Cheers,

  Todd