Post reply

Stop (pause) a transaction or exclude tsql code

  • 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

  • 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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • May 10, 2006 at 11:02 am

    #637057

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

    Cheers,

    Todd

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

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