Run the following query to setup search for version 8.
EXEC sp_fulltext_database 'enable'
DECLARE @SQL varchar(2000)
DECLARE @DataBaseName varchar(100)
set @DataBaseName = (SELECT DB_NAME() as dbname)
set @SQL = 'DROP FULLTEXT CATALOG ['+ @DataBaseName +'FullText]'
EXEC (@SQL)
set @SQL = 'CREATE FULLTEXT CATALOG ['+ @DataBaseName +'FullText] AS DEFAULT'
EXEC (@SQL)
DECLARE @BDWebCategoriesKey varchar(100)
DECLARE @BDItems25Key varchar(100)
SET @BDWebCategoriesKey = (SELECT name FROM sysobjects with (nolock) WHERE parent_obj = (SELECT id FROM sysobjects WHERE Name='BDWebCategories') AND xtype='PK')
SET @BDItems25Key = (SELECT name FROM sysobjects with (nolock) WHERE parent_obj = (SELECT id FROM sysobjects WHERE Name='BDItems25') AND xtype='PK')
set @SQL = 'CREATE FULLTEXT INDEX ON BDWebCategories (Description,LongDescription,PageTitle,MetaDescription,MetaKeywords,SubTitle,MediumDescription) KEY INDEX ' + @BDWebCategoriesKey
EXEC (@SQL)
set @SQL = 'CREATE FULLTEXT INDEX ON BDItems25(Item_No,ShortDescription,LongDescription,MetaDescription,MetaKeywords) KEY INDEX ' + @BDItems25Key
EXEC (@SQL)
alter table IMItmIdx_Sql drop constraint pk_imitmidx_sql
CREATE UNIQUE INDEX pk_imitmidx_sql on IMItmIdx_Sql(Item_No)
CREATE FULLTEXT INDEX ON IMItmIdx_Sql(Item_No,Item_Desc_1, Item_Desc_2) KEY INDEX pk_imitmidx_sql