Custom
SQL Server can install custom sort orders from definition files as they become available. A sort order definition file can have any legal filename, but the convention is to use the filename extension .SRT.
To install a custom definition file
-
If SQL Server is not yet installed, start the setup program and install SQL Server. Or after the server is installed, from the Microsoft SQL Server 6.0 program group start the setup program and choose the option to rebuild the MASTER database.
-
Follow the on-screen instructions until the Installation Options dialog box (for a new installation) or the Rebuild Options dialog box (for a MASTER database rebuild) appears.
-
Select the Order button.
-
From the list in the Sort Orders dialog box, scroll to the bottom and select Custom; then choose OK.
-
Continue with setup, following the on-screen instructions until the SQL Server Path dialog box appears.
-
If necessary, insert the disk containing the definition file into the disk drive.
-
In the Sort Filename box, enter the full path to the definition file. Include the drive letter, directory, and filename.
-
In the Sort Order Number box, enter the sort order ID.
If a sort order ID is specified in documentation provided with the definition file, use that number. If no sort order ID is specified, use any number not currently used for a sort order. For a list of sort order IDs for the sort orders provided with SQL Server, see Sort Order IDs.
-
Choose the Continue button and continue with setup, following the on-screen instructions until the installation or rebuild is complete.