Full Text Catalog Scripting

When rebuilding a replication set it seems that the target db loses its
full-text catalog. Is there a way to script the addition of the full--tect
catalog to the target db? Thanks.
I am not sure what you mean. On SQL 2005 you need to choose to replicate
full-text indexes and ensure you have enabled your database for fulll-text
indexing. In SQL 2000 you must ensure that in your snapshot options you
delete all data in the table should the table already exist on the
subscriber.
Hilary Cotter
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
"DC_SQL_GUY" <DCSQLGUY@.discussions.microsoft.com> wrote in message
news:BA030F09-4D46-4999-853A-27A0DE9471B1@.microsoft.com...
> When rebuilding a replication set it seems that the target db loses its
> full-text catalog. Is there a way to script the addition of the full--tect
> catalog to the target db? Thanks.
|||Hilary,
I drop all of the tables on the target before recreating the replication
set. Thanks for the assistance.
Sincerely,
Todd
"Hilary Cotter" wrote:

> I am not sure what you mean. On SQL 2005 you need to choose to replicate
> full-text indexes and ensure you have enabled your database for fulll-text
> indexing. In SQL 2000 you must ensure that in your snapshot options you
> delete all data in the table should the table already exist on the
> subscriber.
> --
> Hilary Cotter
> 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
>
> "DC_SQL_GUY" <DCSQLGUY@.discussions.microsoft.com> wrote in message
> news:BA030F09-4D46-4999-853A-27A0DE9471B1@.microsoft.com...
>
>