I get the following scenario in my hands: I have a datacenter placed at
the company headquarter and around 200 branch offices spreaded across
Brazil´s states. Each one of them has one SQL Server that holds the databases
of 9 important applications. We now received a strategic ...

What's the easiest way to script SS 2000 Replication?  I don't see a "script
wizard" or anything similar.

I am using merged publication. Now I need to add a new table in the merged
publication. I guess I have to delete this publication and rerun the
publication script to take into account of the new table. However in the
current publication I have a big table which has already been ...

I have two table with the same data but rowguid are different. I have
a conflict with violation of primary key. How can I align rowguid
without delete row (they are in foreign key with other table) ?

Does anybody know from which service pack
compensate_for_errors property  is available for SQL Server 2000?
Any experience using it?
Reading the dokumentation i understand that conflict rows will be never

Is it possible to change the 'agent profile' for a subscription via
tsql??   If so how.....
I need to swich from the 'Default agent profile' to 'Continue on data
consistency errors' let the everything catch up, then swap back to

I'm getting this error from my log reader agent:
Unexpected TIB log record encountered while processing TI block for
offset 0, last TIB processed : (textInfoFlags 0xfffffff4, coloffset
8000, newSize 0, oldSize 4294967296). (Source: MSSQLServer, Error

I have a customer that apparantly replication was setup at some point
(eventhough they say they never did it). We have run exec
sp_removedbreplication 'city' and the tables seem to not be replicated,
but when I try to drop a view, function, or stored procedure I get a

I have this question.
I have a SQL2005 cluster that is using Mere Replication (SQLCE subscribers).
When i add a new table that i want to replicate SQL2005 recreate the
snapshot?

We use replication today and we have around 10 subscribers that are read
only copies.
As we are trying to save costs, I want to look into the feasibility of
replicating from SQL Server to MySQL similar to transactional replication

I was trying to configure a SQL 2005 server as distributor and getting
below error.
There is no remote user 'distributor_admin' mapped to local user
'(null)' from the remote server 'repl_distributor'.

Log reader agent failed and will not restart without error. Switching on
output for agent and setting verbose level to 4 provides this output (last
few lines included here only...)
2008-01-28 13:05:35.383 Status: 0, code: 20011, text: 'The process could not

I have implemented Merge replication on Microsoft SQL Server
(publisher: SQL Server 2000 Standard with SP4, subscribers: MSDE 2000
with SP4) and from time to time I see in Merge replication history
that some merge agent is retrying for days (at least Enterprise

   I have a set up a merge publication with pull subscriptions. When the
subscribers synchronize, we get the error:
Could not connect to server [SQL Server Name] because 'distributor_admin' is
not defined as a remote login at the server.

Group,
I cannot create a Distribution Server on SQL Server 2005 SP1.  When I right
click on Replication and click "Configure Distribution" and hour glass
appears for a minute, and then nothing happens.