Ken,
Don't mis-read what I wrote. I'm not saying that setting the connection to implement manual transactions is wrong. I was only filling in the backgroud with what I know.
The only place that you might run into issues is if you forget to commit or rollback the transaction. The other thing to remember is that a SELECT query will also start a transaction. You can see this with the following:
set implicit_transactions on
select * from authors
select @@trancount
run this in the QA. Don't forget to issues a ROLLBACK to kill the transaction.
-Mike