[RESOLVED] [2005] Timeout when in a transaction

[aconybeare]

Mendhak,

Thanks for that, it's worked I've had a look around but can't see how to handle a forced rollback If one of my nested functions or SP's returns false without raising an exception how do I ensure everything is rolled back. Is the following snippet valid?

Using scope As Transactions.TransactionScope = New Transactions.TransactionScope()
    Using myCon
        '....
        If iCmdResult = 0 Then
            scope.Complete()
        End If
    End Using
End Using

If an non exception error occurs then scope.complete will not be called. Will that force a rollback?