Sql Server 2005 Full Text Indexing on Sql Server 2000 compatible databases?

Sql Server 2005 Full Text Indexing on Sql Server 2000 compatible databases?

Post by Ben Fidg » Fri, 16 Dec 2005 01:49:46


Can anyone confirm whether Full-Text Indexing can be setup on a Sql Server
2000 compatible database running under Sql Server 2005?

Thanks

Ben
 
 
 

Sql Server 2005 Full Text Indexing on Sql Server 2000 compatible databases?

Post by Hilary Cot » Sat, 17 Dec 2005 03:05:40

It works for me!

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/

 
 
 

Sql Server 2005 Full Text Indexing on Sql Server 2000 compatible databases?

Post by Ben Fidg » Sat, 17 Dec 2005 07:53:13

Hi Hillary,

If I try and set up a full-text index on a 2000 compatible database using
Management Studio, the Full-Text Index menu is greyed out. However, on a
2005 database it isn't. I assumed that the new FTI wasn't compatible.

Ben
 
 
 

Sql Server 2005 Full Text Indexing on Sql Server 2000 compatible databases?

Post by Hilary Cot » Sat, 17 Dec 2005 11:51:51

It works for me through WorkBench as well. Are you logged on as a system
administrator?

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/