"Methodology" <Methodology@discussions.microsoft.com> wrote in message
news:55FB7197-DD44-4918-A72A-9AB338481A92@microsoft.com...
> Hi
>
> ive been having masive problems setting up replication between to sql 2005
> whgrp boxes. following advise from here Im now following these steps:
>
> 1. Create publication and select 'copy full text indexes' to true
>
> 2. Create replica database, and tick to allow full text replication and
> run
>
> sp_fulltext_database 'enable'
>
> From query prompt opened with rep dbase selected.
>
>
> 3. reinitialize snapshot BUT DO NOT CREATE SNAPHOT NOW
>
>
> 4. Run
>
> sp_changepublication '<yourpublicationname>', 'sync_method', 'native'
>
>
> From query prompt opened with primary dbase selected.
>
>
> 5. create snapshot.
>
> 6. create subscription and run.
>
> ive got past the
>
> Cannot use a CONTAINS or FREETEXT predicate on table or indexed
>
> error, and im now getting:
>
> Date 7/21/2006 2:48:12 PM
> Log Job History
> (METHODOLOGY9-Mailarchive-Mail_Archive_Pub-METHODOLOGY-AKJ-mail-2F6DE092-1619-49F4-B5DD-10691BB8355F)
>
> Step ID 1
> Server METHODOLOGY-AKJ
> Job
> Name
> METHODOLOGY9-Mailarchive-Mail_Archive_Pub-METHODOLOGY-AKJ-mail-2F6DE092-1619-49F4-B5DD-10691BB8355F
> Step Name Run agent.
> Duration 00:00:16
> Sql Severity 0
> Sql Message ID 0
> Operator Emailed
> Operator Net sent
> Operator Paged
> Retries Attempted 0
>
> Message
> 2006-07-21 13:48:28.250 Category:COMMAND
> Source: Failed Command
> Number:
> Message: CREATE FUNCTION "dbo"."SearchFrom"
> (@paramid bigint, @hash bigint)
> RETURNS TABLE
>
> AS
>
> RETURN select "id" from dbo.arc_add WHERE
> (
> ((SELECT operator from _queryParams where pid=@paramid)
> = '=' AND (email = (SELECT param from _queryParams where pid=@paramid) OR
> "name" = (SELECT param from _queryParams where pid=@paramid)) AND type=0)
>
> 2006-07-21 13:48:28.250 Category:NULL
> Source: Microsoft SQL Native Client
> Number: 208
> Message: Invalid object name 'dbo.arc_add'.
> 2006-07-21 13:48:28.250 Category:AGENT
> Source: AGENT
> Number:
> Message: Unable to replicate a view or function because the referenced
> objects or columns are not present on the Subscriber.
>
>
> anyone?
>
> thanks
>
> Alastair Jones
>
>