Re: How does locking work in MSDE

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Greg Low [MVP] (greglow_at_lowell.com.au)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 10:35:41 +1000

Hi Chris,

Exactly the same as in SQL Server. Locks are applied at the row level but
can be escalated up to larger objects if needed. So, yes, fine grained.

HTH, 

-- 
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Chris Bruyere" <none> wrote in message 
news:OQCT%23RmqEHA.348@TK2MSFTNGP15.phx.gbl...
> Hi All. How does file locking work in MSDE? Coarse grained, fine grained?
>
> Thanks
> Chris
>
>

Relevant Pages

  • Re: locking
    ... escalates to a page level lock from a row level. ... SQL Server MVP ... Default is row level, but optimizer may escalate it to page ...
    (microsoft.public.sqlserver.server)
  • Re: Row level and column level permissions.
    ... "Arun" wrote in message ... column level permissions in an SQL server database. ... i could find some recommendations for implementing row level permissions.(I ... be applicable for my reporting tool(either crystal or sql reporting ...
    (microsoft.public.sqlserver.server)
  • RE: encrypt sensitive data
    ... the Crypto classes. ... SQL server 2005 will support encryption at row level. ...
    (microsoft.public.sqlserver.security)
  • Re: Getting the Name of an MSDE Install
    ... MSDE Manager SQL Tools ... "Wayne Wengert" wrote in message ... >I am trying to verify the "name" of the MSDE installation on a system. ... > HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server ...
    (microsoft.public.sqlserver.msde)
  • Re: Evaluating Xml vs. One field per row in vertical app
    ... Did you take a look at some the SQL Server 2005 XML whitepapers on MSDN? ... Note that in SQL Server 2005 the granularity is still at the row level and ...
    (microsoft.public.sqlserver.xml)