|
Home > Archive > MS SQL Server > March 2005 > SQL 7 page level lock?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL 7 page level lock?
|
|
|
| Hi,
We have sql7 with sp4. Need to know how do I check our dbs are page level or
record level locking>
Thanks in advance
| |
| Mike Epprecht \(SQL MVP\) 2005-03-31, 8:01 pm |
| Hi
It is not a configuration setting. SQL server determines which one to use
based on the query. Most of the time, it will use Page Level Locking.
In SQL 2000, row level locking is generally automatically used.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"mecn" <mecn2002@yahoo.com> wrote in message
news:On1W3ziNFHA.2144@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> We have sql7 with sp4. Need to know how do I check our dbs are page level
> or
> record level locking>
>
> Thanks in advance
>
>
| |
|
| Thanks a lot.Mike
"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:eFwbbsjNFHA.3328@TK2MSFTNGP14.phx.gbl...
> Hi
>
> It is not a configuration setting. SQL server determines which one to use
> based on the query. Most of the time, it will use Page Level Locking.
>
> In SQL 2000, row level locking is generally automatically used.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "mecn" <mecn2002@yahoo.com> wrote in message
> news:On1W3ziNFHA.2144@TK2MSFTNGP09.phx.gbl...
level[color=darkred]
>
>
|
|
|
|
|