sql server replication: Given that , apparently SQL Server 2000 replication will not support
full-text indexing
does anyone have any good workarounds or method suggestions to accomplish a
reasonably up to date copy on a secondary server ?

Any advice greatly apprecaited.

Use the post snapshot command to full-text enable the database, create the
catalog, create the full text indexes, and enable change tracking.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Steve,
note that some of this is still required in SQL Server 2005 as well:
http://www.replicationanswers.com/FTI2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Hi there Paul,

Does the same information hodld true for merge replication in SQL 2005? I am
struggling to get our FTI to replicate and running out of ideas. I also
posted another message about this yesterday, with the subject "SQL 2005 -
Full Text Index and Merge Replication". Any help would be appreciated.

Kind regards,

-Pat Ramadass

[quoted text, click to view]