Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Lock Size

Posted on 1997-12-11
2
Medium Priority
?
355 Views
Last Modified: 2012-08-14
How do I change the number of locks in MS SQL 6.5. I need to do so because I
am upsizing my Access database to mssql and it needs more locks.

Ta Mate.
0
Comment
Question by:battle
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 9

Accepted Solution

by:
cymbolic earned 100 total points
ID: 1089586
In the server configuration section, under the configuration tab, is an item for the maximum number of locks.  You need to set this number up, then stop and start your server to get it activated.
0
 
LVL 9

Expert Comment

by:cymbolic
ID: 1089587
Sorry, I neglected to say that you get to these setup screens using the SQL Enterprise Manager, under the server>configuration Options menu.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question