jliu (5/12/2009)

---

Thank you both for your replies. I randomly checked a few tables between the publisher and the subscriber, they seemed to match. I will run the sp to validation...

Simon Smith (5/11/2009)

---

Thanks for that.

I agree entirely - 3rd party products just up the price everytime. Each edition of SQL gives us more to use. If we can use standard...

You are probably having hardware setup issues. I replicate a lot more than that in one hour.

I prefer the "normal" common sense of removing subscribers then publishers and finally distributors.

The exact opposite way of the upgrades.

😀

Now, that's FUNNY!

Immediate updating subscribers are "by far" NOT the typical use of Transactional replication.

In...

Did you find "sp_MSins_t_ElecConnData" on the subscriber?

It fail because of "data" errors or because "connectivity" errors ?

Can you post a sample Error Message?

Please, post the DDL of your table so that Lowell don't have to WAG anymore 🙂

Dean,

If you can solve the problem possibly in one table pass with appropriate indexes temp tables are likely not needed.

If your tables are heavily modified temp tables aleviate locking/blocking/deadlocking issues.

The...

Julius,

Coding this way ( with exists ... ) is NOT needed at all.

Set up a primary key and if there is a collision handle the error accordingly.

Leave locking to...

We use Transactional Replication and Run our reports on the subscriber.

It has worked very well for us.

Google for Active-Active SQL Server Cluster

The Error indicates that the Replication "ins" ( insert procedure for table t_ElecConnData) is...

The problem you described has nothing to do with replication but with software design. It is client-side responsibility to determine where to connect.