Updating an identity column

Posted by / 01-Jul-2020 13:06

Updating an identity column

When setting up replication there are many things to think about and many options you can choose from when setting up your publications and subscriptions.

In most cases replication is an after thought and not part of the original database or application design, so there may be some required changes that need to be done when replication is setup.

All tables should have a primary key when they are created, but sometimes this is not addressed and for replication to work this needs to be setup.Although it is great that SQL Server handles the not for replication setting for you, what is the process to turn this off or turn this on for tables?The "Not For Replication" setting for identity columns allows replication to pass the ID value from the publisher to the subscriber without the subscriber creating a new ID.In addition, if you are using merge replication you need to have a Row Guid column.Also, if you use identity columns you need to make sure the not for replication parameter is turned on.

updating an identity column-62updating an identity column-77updating an identity column-81

Thanks to one of our readers for pointing this out.

One thought on “updating an identity column”

  1. The two girls are enjoying a brew before they start to enjoy each other. Overjoyed by my response, she began stroking me faster and faster, becoming increasingly enthusiastic by my corresponding cries of bliss. Due to the current rise of economy and cost of living some ladies are being pushed to prostitution in order to earn a living. Or if you’d rather see other areas of North Yorkshire where you can find Bondage then there are many other such pages.