If the publisher deletes a row of data on a table where the subscriber has a foreign key constraint, then next time this happens it is going to break again....

Since I know from your previous post on the other forum that this table is not part of the replicated tables but an additional table in the subscriber, you should...

Do you see any high IO on the distributor or Subscriber?

And here is a wild question, Do you have antivirus installed on the servers and is it set to run...

usually when you create a primary key, the default it creates is a Clustered Primary Key. But you do not need to create it that way. You can create a...

Replication could slow down when the distribution log clean up job runs. This is just one issue. If the Disk IO is busy, it could slow down replication. This can...

One error could lead to lots of other troubles...Thats my experience though. Did this happen by mistake? Someone deleted in subscriber when it should have been done in Publisher? You...

Seems very quite here at the water cooler. That would mean everyone is behaving? 😛

Did I have a siting of Gail in the forums or was it just my imagination?

Check this link[/url] for Row level version

But test it out in a test environment before doing anything to your production.

When you have bulk updates and inserts, the table gets exclusive lock during that time. If you want your Selects to work, there are two ways to do it.

1....

If you are doing regular transaction log back ups, there is actually no need to shrink or truncate the transaction log. When you do a transaction log back up, it...

If my understanding is correct, Master key just protect the private key of certificates and asymmetric keys that are present in the DB. It is the certificate that matters in...

Telepathy... Thats what you all lack....:-D

Glad I could help... Send out the Six pack by post...;-)

If you script the Publication, check what is the value for @repl_freq. If it is continuous, then it updates the subscriber immediately.

It depends.

It depends on the type of replication. If it is Snapshot replication, it will be scheduled to run at a certain interval. But if it is Transactional replication...