fm_fts_setup.sql
If Exists (Select * From sysobjects Where name = N'fm_fts_setup' And user_name(uid) = N'dbo')
Drop Procedure dbo.fm_fts_setup
Go
CREATE procedure fm_fts_setup
(
@catname sysname = 'FmLib_Catalog',
@catpath nvarchar(100) = 'C:\MSSQL7\FTDATA'
) as
set nocount on
exec sp_fulltext_database 'enable'
if exists (select ftcatid from sysfulltextcatalogs where name=@catname)
begin
exec sp_fulltext_catalog @catname, 'stop'
exec sp_fulltext_table 'subject', 'drop'
exec sp_fulltext_table 'author', 'drop'
exec sp_fulltext_table 'title', 'drop'
exec sp_fulltext_catalog @catname, 'drop'
end
exec sp_fulltext_catalog @catname, 'create', @catpath
exec sp_fulltext_table 'title', 'create', @catname, 'PK_Title'
exec sp_fulltext_column 'title', 'title', 'add'
exec sp_fulltext_column 'title', 'ISBN', 'add'
exec sp_fulltext_column 'title', 'notes', 'add'
exec sp_fulltext_table 'title', 'activate'
exec sp_fulltext_table 'author', 'create', @catname, 'PK_Author'
exec sp_fulltext_column 'author', 'fname', 'add'
exec sp_fulltext_column 'author', 'lname', 'add'
exec sp_fulltext_table 'author', 'activate'
exec sp_fulltext_table 'subject', 'create', @catname, 'PK_Subject'
exec sp_fulltext_column 'subject', 'text', 'add'
exec sp_fulltext_table 'subject', 'activate'
exec sp_fulltext_catalog 'FmLib_Catalog', 'start_full'
Go