INF: Manual Installation of Sort Orders

ID: Q95585

The information in this article applies to:

SUMMARY

The SQL Server 4.2 "System Administrator's Guide" does not document how to install a sort order when building the master device.


MORE INFORMATION

These steps should be taken after running bldmastr, but before bringing sqlservr up in single user mode as documented on page 312 (180 in OS/2 4.2 documentation) of the "System Administrator's Guide":

Note the code page and sort order IDs from the ERRORLOG of the last run of SQL Server. The IDs are identified from the following entries in the ERRORLOG: 


   92/10/26 09:16:54.18 server  SQL Server's default sort order is:
   92/10/26 09:16:54.25 server                      'caseless_34'
   (ID =49)
   92/10/26 09:16:54.31 server  on top of default character set:
   92/10/26 09:16:54.37 server                      'cp850' (ID = 2)

In this example, the sort order ID is 49 and the code page is 850. Master must have the same sort order and code page installed as it was running with previously; otherwise, no database dumps from the old system can be loaded, and user data may be inaccessible.

Make a new directory as follows,
md c:\sql\charsets
md c:\sql\charsets\cpnnn

where nnn is the code page the system was running with (either 850 or 437--almost every system will be running with code page 850).

(NOTE: In some versions of sql server this directory will be created by the setup program. If this is the case verify that the desired files are available skip the unpacking of the files and continue with the section that starts: "Change directory (CD) to the C:\SQL\DATA ...".)

Unpack the proper sort order file from SQL Server Disk 2. All packed SQL Server files must be unpacked using the UNPACK.EXE utility on the SQL Server Setup disk. The proper file to unpack is determined by the sort order ID: 

   Sort
   ID   File
   ---------
   30   CP437BIN.437
   31   DICTION.437
   32   NOCASE.437
   33   NOCASEPR.437
   34   NOACCENT.437
   40   CP850BIN.850
   41   DICTION.850
   42   NOCASE.850
   43   NOCASEPR.850
   44   NOACCENT.850
   49   NOCASE34.850
   50   ISO_1BIN.ISO
   51   DICTION.ISO
   52   NOCASE.ISO
   53   NOCASEPR.ISO
   54   NOACCENT.ISO
   55   ALTDICT.850
   56   ALTNOCSP.850
   57   ALTNOACC.850
   61   ALTNOCS.850

Packed filenames are identical to those above, except the last character is replaced with an at sign (@). For example, CP437BIN.43@ is for sort ID 30). The command to unpack the sort order ID 49 or 30 file is:
unpack nocase34.85@ c:\sql\charsets\cp850\nocase34.850
-or-
unpack cp437bin.43@ c:\sql\charsets\cp437\cp437bin.437

Change directory (CD) to the C:\SQL\DATA directory and start SQL Server as follows:
sqlservr

After SQL Server initializes, open a new screen group and run the CHARSET utility referencing the file unpacked earlier:
charset -P<sa_password> -Lc:\sql\charsets\cpnnn <filename>

For example:
charset -P<sa_password> -Lc:\sql\charsets\cp850 nocase34.850

   -or-
charset -P<sa_password> -Lc:\sql\charsets\cp437 cp437bin.437

After CHARSET completes, run the ISQL utility
isql /Usa /P<sa_password>

and execute the following commands (substitute the sort order ID for xx): 

   update sysconfigures
   set value = xx
   where config = 123
   go
   reconfigure with override
   go
   shutdown
   go

Go back to the screen group that SQL Server was running in. Remain in the C:\SQL\DATA directory and restart:
sqlservr

SQL Server should now display a message indicating it has successfully changed the default sort order and is shutting down after verifying system indexes.

You must now complete all the steps remaining on pages 312,313 and 314(180, 181 and 182 in OS/2 4.2 documentation) of the "System Administrator's Guide," beginning with "Starting SQL Server in Single- User Mode" on page 312 (180 in OS/2 4.2 documentation).

Additional query words: 4.20 doc error Windows NT 


Keywords          : kbsetup SSrvAdmin SSrvDoc_Err SSrvInst 
Version           : 4.2
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 16, 1999