I have over 500 transaction records in a single DB process handling within SQL transaction (Begin, Commit, RollBack and End).
Is there any limitation for the following rollbacktransaction function to handle more records (eg. over 500 records)?

 

        Public Shared Sub RollBackTransaction()
            Dim transactionObj As Object
            Try
                transactionObj = SqlTransaction.GetExistingTransaction
                If (Not IsNothing(transactionObj)) Then
                    CType(transactionObj, SqlTransaction).RollBack()
                End If

            Catch ex As Exception
                Throw New Exception(ex.Message)
            End Try
        End Sub

---

** http://www.ReadyShoppingMall.com **
** FREE SHIPPING, FREE GIFTS & UP TO 80% DISCOUNT! **
** A marketplace designed to help consumers more efficiently shop for products from trusted manufacturers & merchants. **