I would recommend using stored procs to put your transaction in. Use the SQL 2005 try catch block and return the indentity in the try along with the commit. Obviously rollback in the catch. This way you can even make a second attempt to insert a record right in the sp.