Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
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
Post Follow-up to this message
Re: SQL 7 page level lock?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 > >
Post Follow-up to this message Re: SQL 7 page level lock?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 > >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
