Are stored procedures rolled back?

While writing my application, I thought I'd be all clever and use stored procedures for some functions which might involve a lot of records. While some of these are reading only (returning total fields), others update data.

It has just occured to me that the NetTiers TransactionManager might not be able to roll back any changes that were made in a stored procedure. Is this the case? Or is NetTiers smart enough to deal with that too?

 Thanks.

This really isn't a nettiers thing.  It is just using the Transaction built into the .NET.  Transaction Manager just wraps this functionality.  You just have to make sure if your calling nettiers multiple times (calling the DB), you need to use the same transaction manager so all calls are wrapped into the same transaction.

Short answer is yes, anything done in the DB is rolled back if the transaction is rolled back.

jeff