>I have a Transaction begun with IsolationLvel set to serilaizable.
>I understand that this will prevent any other users from updating the data until I have committed the transaction.
>
>Can a different user issue a 'Select * ' (No Updates being done) while I am in the middle of the transaction and will they get the data immediately ?
>
>Tia
>Gerard
Take a look at this blog post - it is very helpful
http://aboutsqlserver.com/2011/04/14/locking-in-microsoft-sql-server-part-1-lock-types
If it's not broken, fix it until it is.
My Blog