Home > IT Answers > SQL Server > Problems replicating SQL Server 2000 table
Systems Channel ATE
15 pts.
 Problems replicating SQL Server 2000 table
SQL Server 2000, SQL Server errors, SQL Server replication, Systems Channel
I'm having problems replicating a table that is full text enabled using SQL Server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed. I have run sp_fulltext_database 'enable' on the subscriber. What do I need to do to get this working? Thank you.

Software/Hardware used:
ASKED: August 4, 2008  6:13 PM
UPDATED: August 4, 2008  7:47 PM
RELATED QUESTIONS
Answer Wiki:
Full text indexes are not replicated. You'll need to configure the full text index on the subscriber manually.
Last Wiki Answer Submitted:  August 4, 2008  7:46 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,520 pts.