2012年2月25日星期六

Disabling merge distribution change my table definitions at publisher

I have merge replication between sql 2005 SP1, and when I disable distribution from my publisher, my tables with identity columns change the property "Not for replication" to "NO", does somebody knows if this is a known problem ?

Other information : the compatibilty level for database is 2000.

Do you see a problem with that?

Typically when replication is involved, Not For Replication is needed because when the identity value is tried to insert on the other node, this constraint needs to be skipped. Now with no replication on the machine, it would not matter if this property is ON or OFF.

没有评论:

发表评论