@Grant: Ouch. That doesn't sound nice at all!

@steve-2: While I was jokingly referring to you with that remark (surely the head of any SQLServer site MUST be an experienced DBA?), it is nice to know what's going on behind the scenes here. How long did it take to write with nHibernate? How long do you think it would've taken without it?

@Gift: Thanks Gift, but I was trying to emphasize that the database was a legacy (SQL2000) database and so "SCOPE_IDENTYTY()" wasn't available (AFAIK...) We're now on SQL2005 so things are a bit better now.