HI all
I want to convert the database from all page lock to datapage orp datarow
lock.
what are the things i should be looking out for, or what are the other
paramerts needed to set this up.
all the tables in all the databases are set to allpage locks. I do not know
if this is advisable . my production system is getting extremely slow.

thanks in advance

The syntax is pretty simple (alter table tablename lock datarows), but this
is something I do when I identify a need (it's not the fastest access
method), not because the system is getting slow. Slow systems can have a
myriad of causes.

Now, if blocking has been identified as the reason the system is slow,
that's another story.

Jeff

"Nik" <sqlserverkb (AT) yahoo (DOT) com> wrote