Chapter 13 -- Locking

Chapter 13

Locking is a crucial function of any multiple- user database system, including Microsoft SQL Server. As you know, SQL Server manages multiple users simultaneously and ensures that all transactions observe the properties of the specified isolation level. At the highest isolation level, Serializable, SQL Server must make the multiple-user system yield results that are indistinguishable from those of a single-user system. It does this by automatically locking data to prevent changes made by one user from unexpectedly affecting work being done by another user on the same database at the same time.



Inside Microsoft SQL Server 7.0
Inside Microsoft SQL Server 7.0 (Mps)
ISBN: 0735605173
EAN: 2147483647
Year: 1999
Pages: 144

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net