just a note to say that isolation level is set at the connection level and that the default is read committed and that if another isolation level is desired it needs to be set in the connection