Your starting point for database programming, including answers to frequently-asked technical questions about database development, Get Help with DB2 and SQL Server, feature articles, links to the best database development sites, and news about database tools and updates.
Ugh. We just learned a nasty truth about SQL Server's transaction handling, so here's some Google-juice for others with a similar problem. In our code, we were using SqlTransaction objects to maintain a transaction while updating the database.