Use the following steps to create the FmLib database with a sample set of library materials.
Important If you have added data to the FmLib sample database that you would like to keep, follow the steps found in Updating the SQL Server Database for CML/LitCrit instead.
To set up a new SQL Server database
create database FmLib on primary
(filename='C:\MSSQL7\Data\FmLib_Data.MDF' )
LOG ON (filename='C:\MSSQL7\Data\FmLib_Log.LDF',maxsize=120)
FOR ATTACH
Note When you set up your SQL Server database, you can choose the character set and sort order it will use. The FmLib database requires the ISO character set and the "Dictionary," "case-insensitive" sort order. 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 FmLib
go
exec fm_fts_setup 'FmLib_Catalog', 'C:\MSSQL7\FTDATA'