You can run:

sp_mergedummyupdate 'tablename', rowguid

on the second server to get it to create metadata to replicate to the third server.  This isn't a long term solution though.  It sounds like...

LANMan,

I used to see this error all the time.  It happens when a backup file is corrupt, usually due to a failed backup when you run out of disk space,...

It looks like this is not a replication problem but a corrupt data file problem.  IndexID = 0 is a table heap, most likely for one of the metadata tables,...

I use perfmon all the time to monitor my servers.  I am a domain admin, and thus an administrator on all the machines.  SQL Server rights don't matter, it's the...

I have our replication agent jobs set up to email me if one of them fails.  You can adjust the job properties (where the job runs, distributor or subscriber) and...

I'm not familiar with using multiple files to backup, but when you restore, the data files and log files are created from the full backup set on the fly.  You...

My question would be, why would you want to do such a thing?  Since there should not be any changes in the db since it was restored from the original,...

No, it is not possible to directly change the value of a computed column, as the data is not stored separately.  Sounds like what you need is a default instead...

You CAN do it from EM, you just have to remove the all subscriptions first, like the script does.  I've done this a few times before, also added tables.  But...

I'm not sure how you would do this in DTS 2000, but you should check out SSIS (DTS 2005).  It has ways of changing the configuration at runtime, so you...

It is also possible to use merge replication, which does not require primary keys.

It runs in one big transaction.  If you stop it then it will roll back, which can be a pain, as I found out earlier today.  indexdefrag works in smaller...

However this will give you:

Work

Code Work

Nature

--     --

x        y

Unfortunately this is a presentation issue that should be done at the presentation or application layer.

Dylan

By running this query:

select object_name(id) from syscolumns where name = 'compensate_for_errors'

I got:

sysmergearticles

sysmergeextendedarticlesview

If you're sure you don't need them, you might try deleting those tables.

There's also a remove replication sp...

As I understand it, yes.  Both start the merge agent.  I've done it both ways.

Dylan