• C# Gnu (10/16/2012)


    Addition: so this in effect was my worry - that systems would be locked out while the transaction is open

    If they try to read rows that are locked, they have to wait until the locks are released.

    Chapter 6: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass