Networks

Ask something
Discussion Locked

Microsoft SQL 2000 Server

0 helpful
3 replies

by bfeltus

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have microsofts sql 2000 standard edition already installed on a windows 2000 server. I need to have it configured to the following settings/protocols:

sort order - case insensitive

character sets - iso character set

locks - I need to setto 15000

How do I set these. If I set in enterprise manager, please tell me where. If I need to run a procedure, please show me script(s).Thank you.

3 replies

by ncseric

The sort order and character sets are defined when you install SQL Server and, to my knowledge, cannot be changed without uninstalling and reinstalling the software.

As to the number of locks, they are managed by SQL Server with a minimum of 5000 available. sp_configure gives you the option to set the number of locks; however, if you set the number, it is no longer dynamic. If you set it to 15000, SQL Server will not exceed that number.

Use this stored proc: sp_configure 'locks', 15000

This discussion is closed to new replies.