Lock Size

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.
battleAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
cymbolicConnect With a Mentor Commented:
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
 
cymbolicCommented:
Sorry, I neglected to say that you get to these setup screens using the SQL Enterprise Manager, under the server>configuration Options menu.
0
All Courses

From novice to tech pro — start learning today.