Hi,

Logging everyone who accessed an object is easy, just add the logging code to the proc. (SELECT SYSTEM_USER)

However I'm pretty sure there's no native way to determine if someone...

Hi,

I've had them too and I've tried everything to get rid of them. Sometimes disabling replication on the publisher and removing the distribution database works, but most of the time...

You're getting that just when calling the stored proc or when you run the alter?

If the former, can you send your command you're using to call it?

Have you checked to...

I do not have any merge replication instances to try this on so this is just a suggestion requiring more research.

According to BOL, SQL Server 2005 creates a table called...

What version of SQL Server are you using? What type of replication are you using? I'm guessing transactional.

This message means that the record that replication is trying to update in...

Santhosh,

Your question is too large to write a full step by step answer. I will tell you at a high level how to do it.

First, it is possible to import...

Probably not if you are going with the instead_of trigger, although you might want to start out with a separate db to test it.

Any idea why you end up with...

Is the subscriber/merged db separate from the above dbs?

MH,

I tried to do this on one of my virtual servers just to see if I could make it work. It can't be done because (for starters) you can't create...

When it retries the individual commands does it succeed in replicating them or does that also fail?

If so, does the distribution agent list the record it failed on?

Chris.

Well... I think you COULD put an instead_of trigger on the table for the insert event, and then throw out the duplicate record or better yet, log it somewhere so...

Steve,

I thought so too, and I've never tried without restoring a backup or applying a snapshot but Peter mentioned the NOSYNC option which I looked up in BOL.

Constant Value...

We tried that too. Unfortunately, for us we had to get rid of the subscription db, since you can't, probably because it would affect your reporting. Can you try setting...

Hi Peter,

Sorry, its really difficult to troubleshoot more complex/detailed problems on here.

When you recreated the subscription, did you start with a new subscriber db?

I have not dealt with this...

How did you get the data to the subscriber when you set up replication the first time around?