pardeep (7/14/2008)

---

Ohkay.......

Transactional replication will obviously the last or may be mandatory option left.

Anywys, nw plan is something like....

A and B are clustered, seperate machines, active/active.

Db A -->replication to Db B(on...

My first question would be why are you using a cursor? Are you sure this cannot be done as a set-based process?

No, sorry - those options will not get you real time (or even near real time). The closest you are going to get to real-time is transactional replication.

I have...

Glad I could help.

Yeah, see that now - missed it the first time.

Ken Simmons (7/13/2008)

---

I think this is what you are looking for.

Select Buyer_ID,Order_ID

FROM (

select order_id, buyer_id,

RANK() OVER (partition BY buyer_id Order by order_id)...

rbarryyoung (7/13/2008)

---

This happens to all of us from time to time and you should know that your "lost" text is recoverable, but only immediately afterward.

Whenever you get this message, immediately...

levsha_z (7/13/2008)

---

CREATE TABLE BUYERS (buyer_id bigint, order_id bigint, item_id bigint)

INSERT INTO BUYERS VALUES (1, 32, 8)

INSERT INTO BUYERS VALUES (1, 31, 2)

INSERT INTO BUYERS VALUES (1, 12, 3)

INSERT INTO...

Please read the following article:

Best Practices: http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you follow the above, someone here will be able to help you solve your problem - probably very quickly.

Off the top of my...

obarahmeh (7/13/2008)

---

Deal All,

Thanks for all ur replies.

I found out the error cause, it is not an error in the query. I suddenly found some values in the column DayTransTime (Decimal(6,0))...

Without further information, this is just a WAG on my part. I would guess that you have setup parameters in your report and one or more of your parameters...

Since this...

Well, I don't envy you this task - it is not going to be easy. Any way you can convince the user that the old database should be moved...

The first thing you need to be able to do is identify the data to be appended. But, what about existing data that has been changed in database1? ...

slava davidchuk (7/10/2008)

---

system 1

Resource Group ...