we have setup a sql2005 server for reporting. we want to replicate the
transaction databases which used for live applications to that server such
that all reports will be generated in that server.
This reporting server is supposed read-only and with let's say 30 mins delay

I have several machines that have two merge pull subscriptions for two
databases.  One subscription is set to continuous, the other
subscription is set to pull every hour.  The publications are set to
drop subscribers if they don't synchronize within 14 days.

Is there an easy way to determine the status/progress of the snapshot agent
for a particular merge publication?

How can you determine if a merge agent (pull subscription) is currently in
process?

I want to setup a FTP replication ( snapshot or transactionnal) other 2
SQL 2000 server ( S1 and S2) accross non trust domains ( domain A and
domain B).
neither S1 , nor S2 can have IIS set. So i want to use an FTP server on

I have a subsription that needs to be reinitialized because it has been
marked as inactive. Instead of reinitializing and then have to transfer
a new snapshot, that would caus all sorts of key violations, i would
like to do the following.

after i done the replication from sql server 7.0(pub/dist) with sql server
2000(subscription) there will promt out the error like below :
Agents                 Last Action
Snapshot              No such interface supported.NOTE:The step was retried

Hi
We have configured merge replication in SQL 2005 (SP 1) for a database
having more than 100 GB. The merge agent duration was for every 5 mins.
Normally it used to take around 2 to 3 mins to complete. It was working fine

I have a Sql 2000 Citrix data store on a server which is licensed per
processor.  I have established replication on this server to another
server.   This other server (the Subscriber) is running sql 2000 also
but at this time is only licensed for 5 seats.   Would I need to

What does this mean?  It appears to be keeping the wizard from running the
distributor setup on the server.
Code used is:
use master go

Let me paint the picture :-)
I am a Windows Engineer and I have been asked to create a trust between two
domains, this request has come from our SQL engineers who tells me this is
required to set up SQL Replication.

Good morning,
This morning I opened up enterprise manager (sql Server 2000) and noticed a
blue return arrow looking icon on the Replication Monitor folder.  When I
opened up Replication monitor I observed the same blue return arrow looking

I'm trying to implement .NET based custom resolver for SQL Server 2005. MS
example shows how to work with publisher / subscriber record data only. To
resolve a conflict I need more info about the business object represented by
record data. I need to run a query / procedure for ...

I have a small problem, I get this following error when trying to start
the snapshot agent "The process could not connect to the distributor
'distributor name'. NOTE: The step was retried the requested number of
times [10] without succeeding. The step failed.

I've heard that there was a change in SQL2K5 in regards to what version
of SQL-9x is or is not supported. Can anyone directed me to some
documentation that covers this?
thanks,