Hmmm...tricky one.

By design, if you update a unique constraint in replication, the replicated command becomes a pair i.e. an delete/insert.

Unless you have a composite unique constraint and are updating one...

Hi George,

I think I need to see your table structure.

I think a composite PK is getting a little complicated, it is far easier to manage with identities...I've found anyway 🙂

Regards

Graeme

I would always do this via the scripts.

Just a reminder, Suresh said reinitialize the subscription...you don't want to do that as that will require a new total snapshot.

If you add...

Hi,

When I have had this, I usually change the profile of the agent - typically Logreader, and reduce the batch size right down and increase the timeout. This gives the...

Hi,

I totally agree.

It is quite reasonable to have replication to a DB used by a website..we do it. Ours gathers user data i.e. what they searched etc. The DIST agent...

Hmmm,

That does sound likely.

You might be able to use a specific profile for your logreader but that still does not get away from the large number of transactions for Trans...

Hi,

I assume all the accounts that replication have the proper permissions

Regards

Graeme

Hi,

Primary key violation could be the key already exists...in which case are your identity ranges correct...do you need to reseed. Or if you have triggers, do they need to be...

Thanks for you input Sergiy..

Not sure I made myself totally clear..apologies...

I haven't posted the trigger I was just asking the question about the trigger not firing correctly due to my...

Thanks Sergiy..

I hear what you are saying but the query is incidental to my problem...that is purely the means of testing my problem.

The fact is all my IDs are INTs...

Sorry...idiot that I am..I left a bit out

UPDATE y

SET y.col1 = getdate()

FROM table1 y

INNER JOIN

(select a.id1,a.column2

FROM Table1 a

LEFT OUTER JOIN Table2 b on CAST(b.id AS INT) = CAST(a.ID AS...

Hi,

If you are using Trans or Snapshot replication it is possible to remove just the table from the replication, alter the structure and then republish that article...it's a bit of...

Hi,

As far as Unique identifiers is concerned that's fine unless you want to use the identity i.e. as a companyID or a Userid in which case the INT is the...

If your databases are not too big, a possible solution is to reapply the snaphot

OR...during a weekend

Synchronise the databases and stop any further changes

Drop the replication

Remove the Identity RAnge constraints

Re-apply...

Hey..

After a chat with my esteemed colleague I was reminded....

If you make all your FKs NOT FOR REPLICATION, then when the replication applies the child record, even if the parent...