SQL2005 Replication of a fulltext indexed table

Last post 09-20-2007, 4:57 AM by ACALVETT. 1 replies.
Sort Posts: Previous Next
  •  09-15-2007, 3:54 AM Post number 37296

    SQL2005 Replication of a fulltext indexed table

    Hi,

    I cannot get any changes in a fulltext indexed table to be replicated, all the commands get queued on the distributor and the subscribers never get them. Other tables in the article are delivered on problem.

    Is there something I am missing?

    Thanks

    Rob

  •  09-20-2007, 4:57 AM Post number 37447 in reply to post number 37296

    Re: SQL2005 Replication of a fulltext indexed table

    I've not had much exposure to 2005 replication but reading your post made me wonder if there is a problem with the full text index on the subscribers which may be why its not replicating?

    Have the catalogues been created?

    Whats the first transaction queued at the distributer? Is there something unusual about it?

    Hope this helps a bit
View as RSS news feed in XML