WOW!

I am having the exact same issue and have been beating my head because every single blog and post on this says to kill the process with the UOW!

I am...

have you looked into Change Tracking or ChangeDataCapture and then using that data to transfer what has changed?

It won't be realtime but it can be near real time.

Without triggers or...

CirquedeSQLeil (3/16/2010)

---

TedS (3/16/2010)

---

Greg Edwards-268690 (3/16/2010)

---

TedS (3/16/2010)

---

Am I the only one who copied the code directly and got 3 different result sets for each query?

Granted I used RedGate to generate 500,000...

Greg Edwards-268690 (3/16/2010)

---

TedS (3/16/2010)

---

Am I the only one who copied the code directly and got 3 different result sets for each query?

Granted I used RedGate to generate 500,000 rows in...

Am I the only one who copied the code directly and got 3 different result sets for each query?

Granted I used RedGate to generate 500,000 rows in the example table,...