You often get problems with MSSQL server
when there are no indices supporting your primary or foreign key constraints.
JBossCMP just adds the constraints, it does not add the indicies.
Thanks for the advice. I have seen a few issues users on these boards have been having with sql server. Particularly the way sql server may promote a row lock to a page or table lock. I am stuck with using sql server and am nervous about whether I will be creating problems for myself trying to use it in a clustered environment but will carry on with it and monitor the locking situation.