I have a  table that is part a merge publication that I need to delete 3
million rows from which will leave about a million in the table. I plan to
just insert a list of the id's to go in a temporary table and then just do
delete where id in table X.

I'm considering a solution to retrieve user selections from another source
and automatically use them to set my SQL replication filter criteria. The
filter includes at least one table join. Is it possible to set replication
filter criteria programmatically?

We have a SQL Server 2000 std edition on Win 2003 Server with 10+
offices around the country with with XP clients. Each office has about 5
 to 10 clients with one of the client machines maintaining that
offices' SQL database. These clients are not part of a corp domain. I

My Log Shipping process has been up and running fine for about 6 months now.
Then as part of the preparation for upgrading the front end application for
the log shipped database, my partner DBA thought he would help the backup
speed by running a SHRINKFILE over the database files ...

We have two DataBases Residing on two different Servers. We would like to
set up real time uodates between these two servers.
We have an Inventory System on server A and a Tracking System on Server B.
Now an Transaction in Server B should Update a Certain Table or Tables on

I am using merge replication and trying to configure an alternate
synchronisation partner (ASP). My topology is V-shape and replication is
working OK as long as I do not perform a sync of the subscriber with the ASP.
My subscription contains articles having identity columns ...

Hello, I have 600 gig of data on my disks on windows 2000 server with SQL
Server 7.0. I am using robocopy for fast data transfer between 2000 and 2003
disks.
but my application team wants to set up replication for exact data sync, i

After working for over a year, one of our snapshot replication
distributions now fails with the following error:
The process could not bulk copy into table '"texttab"'.
Expected the text length in data stream for bulk copy of text, ntext,

I have a merge replication setup between two sql 2000 servers. It works
fine, but there is some data in one table
that I wish to hide - at the subscriber database.
This data is in 4 columns in one table. It would be best if I could exclude

I have a publication within a transactional replication with a push
subscription. I had deleted the subscription on the Publisher through the EM.
And Publisher EM showed the subscription is removed. But  when I checked the
Subscriber EM, the subscription is still there under the

I have one publisher and two subscribers, i want to filter the data
dynamiclly before sending it to the subscriber(s), my question is, how to
know the current subscriber when the merge agent implement the filtering
criteria, i tried to use Host_Name() function to know the current ...

I have two databases say A and B on the same server. A is updated through an
Access front end. A is set up to transactionally replicate some of its tables
to B. The
Log Reader does its job - confirmed by running sp_browsereplcmds to see the

has anyone of you experience in replicating Commerce Server 2002 DBs between
two sites? Both sites' web servers are accessible from the internet. Placing
orders should also be possible on both sites.
Is there any recommendation / experience which replication model (mix) is to

the idea is to setup an offsite backup of our single sql server, have
created a publication on the MASTER server, and pulled it to the offsite
server using FTP, downloaded snapshot, replicated transactions, all appeared
to work, generated schema, but the frontend database app ...

there are many "dead" agents (snapshot, protocoll,distribution) in my
enterprise manager of deleted replications .... how can i delete these
agents as well?
thx for help