Problems replicating SQL Server 2000 table
Home > IT Answers > SQL Server > Problems replicating SQL Server 2000 table
Systems Channel ATE
15 pts.
0
Q:
Problems replicating SQL Server 2000 table
SQL Server 2000, SQL Server replication, SQL Server errors, 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.
ASKED: Aug 4 2008  6:13 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Full text indexes are not replicated. You'll need to configure the full text index on the subscriber manually.
Last Answered: Aug 4 2008  7:46 PM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   46795 pts.  |   Aug 4 2008  7:47PM GMT

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

 
0