i have two tables product and productFlavour, which all have
productcode in each table.
so in the table filter. i put product.productCode =
productFlavour.ProductCode.

When i use the "sp_copysubscription" procedure, i am getting the following
error.
"Server: Msg 21236, Level 16, State 1, Procedure sp_copysubscription, Line
64

I have selected merge replication because both servers are constantly
updating information. We have continuous merge replication (push) and
everything works pretty good.
The problem is in some occassions the job stops saying that it can not

the Merge-Agent stops with the following error:
The merge process couldn't recall the information for the table 'xxx'
What is the reasen for the problem ?
What can I do ?

just wondering would it generates trigger for some tables when those tables
doing merger replication.
using sql server 2000
Cheers

after restoring a publisher database, the definitions for the publisher
woudn't be restored completly.
When I try to delete the rstored publisher, I get the message
Error 20026: The publication XXX does not exist.

I have 6 pushmergesubscriptions A,B,C,D,E,F
I wan't to start the merge-agent A at 8.00 PM, B after ending of A, C after
ending of B, D after ending of C, E after ending of  D and F after ending of
E.

how can I start the snapshot-agent in a sql-script ?
Best regards
Axel Lanser

After creating a snapshot job using sp_addpublication_snapshot how do I get
the job_id?
I want to be able to rename the job as well as change the owner through
script after it is created but sp_update_job requires the old name or job id

I have a transactional replication as i mentioned earlier and has 4
publications. My subcriptions had been deacticvated since there was no
syncrnisation diring the retention period. As a result i reinitialised the
subscriptions for each of the publications. Then i ran the ...

Myself and a colleague have been charged with making two SQL servers
(SQL Server 2000 STD) replicate in real time, this is to allow a
helpdesk system to be updated in either the UK or South Africa.
Unfortunately as the helpdesk system we use is not by our own design

I have two servers that I am connecting with Merge replication (SQL2k).  
SERVER1 is the publisher and pushes a subscription to SERVER2.  After the
snapshot is created, the Merge Agent runs but gets the following error:
Procedure or function sp_MSaddinitialarticle has too many ...

Can anyone direct me to resources to read about setting up "usual and
customary" maintenance plans for SQL?

The log reader has stopped on me a couple of times with the error
"The step did not generate any output. The step failed"  
Does anyone know what might be causing this?  Thanks.
Peter Doyle

Periodically, I get a these messages appearing from the System Log. These
errors once started will always continue for the next few hours until the
server is restarted. During then - software distributions seem to fail.
(SystemLog)