Microsoft KB Archive/95585

{|
 * width="100%"|

INF: Manual Installation of Sort Orders

 * }

Q95585

-

The information in this article applies to:


 * Microsoft SQL Server for OS/2, version 4.2
 * Microsoft SQL Server version 4.2x

-

SUMMARY
The SQL Server 4.2 &quot;System Administrator's Guide&quot; 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 &quot;System Administrator's Guide&quot;:

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: &quot;Change directory (CD) to the C:\SQL\DATA ...&quot;.)

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 -Lc:\sql\charsets\cpnnn "

For example:

"charset -P -Lc:\sql\charsets\cp850 nocase34.850"   -or- "charset -P -Lc:\sql\charsets\cp437 cp437bin.437"

After CHARSET completes, run the ISQL utility

"isql /Usa /P"

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 &quot;System Administrator's Guide,&quot; beginning with &quot;Starting SQL Server in Single- User Mode&quot; on page 312 (180 in OS/2 4.2 documentation).

Additional query words: 4.20 doc error Windows NT

Keywords : kbsetup

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbZNotKeyword3 kbSQLServ420OS2