DQS can only be installed on

1.Enterprise edition 64 bit

2.BI edition 64 bit

3.Developer edition 64 bit

I was very cleverly (stupidly) trying it on Standard edition 64 bit.

There was no issue to...

As a matter on ethics, I am obliged to give this update.

MSpub_Identity_Range is a replication object created in the publisher database (during creation of replication).

This was accidentally dropped. I...

Oh! what I missed to add is SQL version..

Its running on SQL 2000. Publisher/Distributor on the same server and subscriber is a different server.

Well, the issue is now resolved. For those who are interested

There are tables with columns defined as FLOAT. 2 such Float columns are part of indices and the rebuild index...

Sugesh, Thanks for the reply. No! there are no computed columns.

Hello,

 The issue still persist. I have checked everywhere and no information is available, except that this is fixed in SP4. But we are on SP4 and no clue moving forward....

Data is replicated only once per subscriber!!

There are couple of things you could try

1. try to disable the replication (menu on right clicking the replication node)

2. if the above fails,Try to create new replication on the...

Noel's last para sums up. leave it as it is! no harm will come. As long as there are not value conflicts or failures, the replication is on its normal...

It does not override. It only makes sure that the Identity property in not set in the Subscriber.

As it is the PK, Replication would use it for comparison...

'Not For Replication' is only for the 'identity' property and not for the column!

When you say replication stopped, which agent failed/stopped?

I am officially stopping to followup with this topic. Any ideas are welcome. I will check this once in a while.

Thanks in advance

Ofcourse, Any thoughts, any ideas....