copying database causes FullText to not work -- sql server full text search

Uyen Nguyen
2/11/2004 4:41:00 PM

I have imported another database onto my existing SQL 2000 database and
found that my Full Text no longer works. Even though I have rebuild the
catalog, whenever a full text query is run no result displays. Why is
that? What do I need to do in order to have Full Text work?

*** Sent via Developersdex http://www.developersdex.com ***

John Kane
2/11/2004 6:44:25 PM

Uyen,
What was the exact method or procedure you used to "import" another database
onto your existing SQL Server database?
Did you use backup and restore or detach and attach or some other method?
Was the source database also FT-enabled and if so, was the FT Catalog
defined with the same exact path, including drive letter? Did the rebuild of
the FT Catalog work successfully with no errors? Did you try to drop and
re-create the FT Catalog?

Regards,
John

[quoted text, click to view]

sql server full text search : copying database causes FullText to not work