To add a little warning regarding transactions when using MS-SQL (or Sybase) - be sure that your transaction log is large enough to hold all of the rows that you update/insert before the commit call.

When the row is inserted it first written to the transaction log. Then when commit() is called it is moved from the transaction log to the permanent location, hence the need to have a properly sized transaction log if you need to run large transactions.

Michael