Thanks John,

I am using hibernate(orm) to access the db. I tried changing the jdbc driver to jTDS and was working fine with default isolation level. Maybe a bug in microsoft...