Why does a full-text search perform so slowly in SQL Server 2005? How can i improve the performance, in general, of query results ?
Answer Question | October 9, 2008 4:00 PM
Full-text databases, SQL Server 2005
I’m having problems replicating a table that has 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 [...]
Answer Question | April 22, 2008 6:14 PM
Full-text databases, SQL Server 2000, SQL Server replication