mardi 3 février 2015

Cannot drop constraint in SQL server 2008


When I try to delete a constraint, it gives me the following message:



"The constraint is used by merge replication for identity management and cannot be dropped directly. Execute sp_changemergearticle @publication, @article, "identityrangemanagementoption", "none" to disable merge identity management, which will also drop the constraint."



However, the replication was deleted from the database earlier by previous users. Now I cannot remove or even modify the constraint. Can you please advice how to remove it now?





Aucun commentaire:

Enregistrer un commentaire