Re: SQL Server 2005 with advanced services and full text search

Tech-Archive recommends: Fix windows errors by optimizing your registry

and here is how I created the db the 1 table and the catalog

create database RSDB2

create table support
(ftid int NOT NULL PRIMARY KEY,
problemId varchar(50) NOT NULL,
problemTitle varchar(50) NOT NULL,
problemBody nvarchar(3850),
lOne varchar(50),
lTwo varchar(50),
lThree varchar(50),
lFour varchar(50))

create fulltext catalog rsCatalog

create unique index ui_support on Rsupport (ftid)

create fulltext index on support (problemBody)
key index ui_support on rsCatalog
with change_tracking auto

insert into support(ftid, problemId, problemTitle, ProblemBody)
values(1,'win1001','testing the database','testing the database for
full text indexing')

select * from support where contains(problemBody, ' "text indexing"
'); ---this search comes back blank

.