Re: Cannot use a CONTAINS or FREETEXT predicate on table...

Yes you are correct.

The only additional thing you need to do on the subscriber is run
sp_fulltext_database 'enable'. Everything else is done on the publisher. You
should not need to run sp_replicationdboption once you have configured your
publication.

--
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



"Methodology" <Methodology@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EE19B5CB-B736-4FFE-A415-EAEC015D4810@xxxxxxxxxxxxxxxx
ok

So

I setup a local publication on the master, and set the full text rep to
true

I create a database on the replica server and set the same value to true.

then I create the subscription and point it at the new dbase on the
replica
that I have just created and configured.

correct?

(I was trying to run the command on the publisher dabse with the correct
dbase name though I understand that I may need to use the
sp_replicationdboption command as well???)

Thanks for your response Hilary.

Alastair Jones



"Hilary Cotter" wrote:

To get this working you have to enable the subscription database for
full-text in advance of creating your subscription. Ensure that you have
selected to replicated the full-text indexes.

From you error message it seems to indicate that you are attempting to
modify a publication which does not exist, or running this in a database
which is not publisher. Make sure you run it in the publication database.

You can also make this modification through the GUI.

--
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



"Methodology" <Methodology@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CF47CAB5-26FE-47F6-8821-80047FFA134C@xxxxxxxxxxxxxxxx
Hi

Im trying to set up SQL replication between two SQL 2005 Workgroup ed
boxes
- Its a Mail archive (created by GFI mail Archiver Program) that I am
trying
to replicate for Disaster Recovery Purposes.

Im a newbie so Im taking a tiny step forward, hitting a wall, Googling
for
half and hour and then progressing another miniscule amount. I cannot
stress
enough how little I know about SQL and how fast im having to learn..

however, I cant get past my latest error.

I have enabled full test replcation on the database that I want to
replicate
- I set the value to 'true' when I set up the snapshot. Then after an
error
and some googling, I ran

use <database>
go
exec sp_fulltext_database 'enable'
go

to apparently tell the replica server that I had infact turned on Full
Text
Searching on the master and to stop being a nobbo and to just get on
with
it.

Now im getting

"Cannot use a CONTAINS or FREETEXT predicate on table or indexed view
'dbo.arc_bodies' because it is not full-text indexed."

I have googled and found the following solution:

sp_changepublication @publication = 'yyy'
, @property = 'sync_method'
, @value = 'native'
, @force_invalidate_snapshot = 1

which I run with no success. I substitue 'yyy' for the name of the
database
AND the name of the publication on BOTH the Master and Replica servers
but
no
matter what I do or where I run it, I get:


Msg 14013, Level 16, State 1, Procedure sp_MSrepl_changepublication,
Line
94

This database is not enabled for publication.


when surely it is???? - publication is setup and the snapshot is
created....

Can someone dig me out of my pit of frustration?

Thanks is advance

Alastair Jones






.

Relevant Pages

  • Re: Cannot use a CONTAINS or FREETEXT predicate on table...
    ... I setup a local publication on the master, and set the full text rep to ... I create a database on the replica server and set the same value to true. ...
    (microsoft.public.sqlserver.replication)
  • Re: Cannot use a CONTAINS or FREETEXT predicate on table...
    ... I setup a local publication on the master, and set the full text rep to true ... I create a database on the replica server and set the same value to true. ...
    (microsoft.public.sqlserver.replication)
  • Need help determining where the problem is in my AD replicas
    ... 8451 The replication operation encountered a database error. ... partition from being hosted on this replica. ... Reason: StaleServersTopology ... Replica link has been added. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Need help determining where the problem is in my AD replicas
    ... 8451 The replication operation encountered a database error. ... partition from being hosted on this replica. ... Reason: StaleServersTopology ... Replica link has been added. ...
    (microsoft.public.windows.server.active_directory)
  • Re: ISFDB Spoiler Policy Question
    ... don't want to check titles 5000+ times. ... have access to a copy of the database and can run scans/exports/etc. ... elements for each printing (note: ... Publication Year (not the copyright year or the year of the first ...
    (rec.arts.sf.written)
Quantcast