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,
0
Comments
ROWLOCK.
http://dynamicslife.dynamicsusers.net/f ... 10175.aspx
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n