The following procedure enumerates the steps necessary to accomplish this task.
To set up a SQL Server database
create database Eval on primary
(filename='C:\MSSQL7\Data\Eval_Data.MDF' )
LOG ON (filename='C:\MSSQL7\Data\Eval_Log.LDF',maxsize=120)
FOR ATTACH
Note At the time that a SQL Server database is set up, you are asked to choose the character set and sort order that the database will use. The Eval database requires the ISO character set and the "Dictionary," "case-insensitive" sort order. If the database has been set up with the normal defaults, these will be the settings in use. Any other settings will produce an error similar to the following:
Server: Msg 1816, Level 16, State 1
Could not attach the database because the character set, sort
order, or Unicode collation for the database differs from this
server.
Warning Sort order 52 in database differs from server sort order of 42.
use Eval
go
exec lw_fts_setup 'Eval_Catalog', 'C:\MSSQL7\FTDATA'