DefaultLockGranularity parameter

xavigepe

Hi. Could anyone explain me what's the use of parameter DefaultLockGranularity when working with SQL Server.
I have read a Microsoft paper where they say that if you create a table using:

CREATE TABLE [$ndo$dbconfig] (config VARCHAR(512) NOT NULL) GRANT SELECT ON [$ndo$dbconfig] TO public

and then insert a row with value DefaultLockGranularity=Yes
then SQL manages locks better. Is that true?. Do I have to restart SQL after inserting this record?

Thanks,

ara3n

When the parameter is Yes SQL Server will choose the granularity of the locks that it places. When the parameter is No Navision will override SQL Server and place
ROWLOCK.


http://dynamicslife.dynamicsusers.net/f ... 10175.aspx