Full Text Search possible for 2000 & 2005 on same pc

Hello:

I am on a development machine with sql 2000 & sql 2005 installed. The full Text Search for sql 2005 is installed and running on this local machine.

However, I need to do a full text search with sql 2000. When I do:

sp_fulltext_database 'enable'

I get:

Full-Text Search is not installed, or a full-text component cannot be loaded.

Can I install full text search for both sql server 2000 & 2005. I read somewhere that this is not possible.

Since fulltext search loads with sql 2005 (I believe), does this mean I can't do an sql server 2000 full text search on a local machine (or server) that has both of sql2000 & sql 2005 installed.

Thanks for any help on this

What you want to do is doable as I've done it. I.e., run both SQL Server 2000 and SQL Server 2005, both with full-text, on the same box.

Your issue is that the full-text option of SQL Server 2000 is not installed by default. In SQL Server 2005, full-text support is automatically installed by default.

So you'll need to install the full-text component of SQL Server 2000. In addition, you'll need to enable the full-text option in each database that you wish to use full-text. Again, it is not enabled by default in SQL Server 2000.

Related commands:

FulltextServiceProperty('IsFullTextInstalled')

IF DATABASEPROPERTYEX(DB_NAME(), N'IsFulltextEnabled') = 0 -- Is database enabled?
EXEC sp_fulltext_database 'enable'; -- Enable option at database

Full text catalog problem

I have a database which has (god knows how) ended up with a Full text catalog which is believes is on the E: drive of the machine. The problem is that machine only has C: drive.

If I try and rebuid the catalog (sp_fulltext_catalog 'documents','rebuild') I get an error saying that e:\... doesn't exist.

If I try and drop the catalog (sp_fulltext_catalog 'documents', 'drop'), I can't because it contains a full-text index.

If I try and drop remove the full text index from the table (sp_fulltext_table 'tbl_upload','drop'), I can't because Full-text catalog has been lost. Use sp_fulltext_catalog to rebuild and to repopulate it.

HELP

Does anybody know how to either drop it so that I can recreate it or how to update it so that it looks at a disk that the machine actually has?I updated the sysfulltextcatalogs table and set the path to null in there, this caused the system to then use the servers default path. I had tried to do this but was fooled by the fact that Enterprise manager claimed the table was empty whereas when I did a select from it from Query Analyser it returned the data.