Doubt in ASP

[Anon]

I'm using the BeginTrans, CommitTrans and RollbackTrans, I'm gettting the errors like
1. "Cannot create new transaction because capacity was exceeded."
2. "No Transaction is active".

Can anyone pls suggest me how to overcome these problems?

Provide me some examples in ASP to work on these transaction

[Anon]

Every time you BEGIN a transaction you need to follow it with either a COMMIT or a ROLLBACK, no exceptions.

You should not have a second BEGIN before the previous one was committed or rolled back, it won't do anything. A COMMIT or ROLLBACK ends the transaction, they don't nest.

Make sure your code doesn't leave transactions open when it finishes, begin a second without committing the first, or tries to commit/rollback more than once.