i want to change the Transactional retention time in a pull subscription replication.my question is can we can retention time to avoid deactivation time without reinitializing the subscription?
thanx in advance
regards
amir

I need to learn the steps to investigate which
transactions are not getting replicated, thus causing my
log file to grow.  I periodically check the dbs I
administer and wait until after hours to force

"The process could not deliver the snapshot to the Subscriber"
I added a new database to the same server as the publisher and distributor.
The error ocurred when pushing a new subscription to it.
I did indicate that the subscriber already has the schema and data.

I'm a little confused.
I've been working on setting up one snapshot publication for one DB, and one
"one-way" transactional publication for another DB (both on the same
server).

Is it possible to configure a linked server to be a replication publisher in
sql server 2000. I have a progress v9.1 database that is configured to act as
a linked server that I would like to make a publisher and then use a sql
server 2000 subscriber. Thanks!

I am trying to complete a distributed query on two seperate sql instances,
two seperate databases, two seperate tables. I am trying to do an insert from
one database to the other when an insert occurs in the originating database.
I have attempted both a trigger running the sql ...

Is there any way to add columns to the database and not have to stop
replication.
I have one publisher with many subscribers and I don't want to delete all
the subscriptions to add columns to my publisher.

This topic has probably been pounded to death, as I've read a considerable
number of posts, yet I haven't exactly found the answer to what is going on
in my situation.
I've got SQL2k running on a Win2kPro box. When I try to create the snapshot

I was trying to simulate a test (losing connection) between three servers
which has the same database replicated.
I have one publisher and two subscribers. I remove the subscription from one
of the subscribers and add a record there.  Then I recreate the subscription

Please, send me link approaches types of replication. I need install this
resource. I have a problem with my remote network and consider that is
solution.

Posted a question in DTS NG and was directed to this NG to ask for Hilary
Cotter or Paul Ibison. I have posted below the reply and then original
question. Any suggestions would be greatly appreciated.
Reply

I have 2 servers replicating two way, using merge agents.
i want to receive a notification(via email preferably) when the merge fails(the notification would run on one server only, the one with the merge agents), but haven't found a clue on how to make this work.
Any ideas are ...

HI NG,
on a testserver mssql2k I have one publication
with NO subscribers
backup LOG ..

I am trying to set up Transactional Replication and here is the
configuration.
Server1 - Publisher
Server2 - Dist

Have been searching for a solution to this problem for several days now, all
to no avail, so hopefully someone will be able to help.
Using Transactional replication on SQL Server 7.0. Multiple subscribers
which subscribe to multiple publications on a server set up as