Remove and Add a Table as an Article of Replication

When upgrading ACM from a DB version 36 or lower to DB version 37 or higher you may see an error message with text similar to the following:
”ALTER TABLE ALTER COLUMN ID failed because on or more objects access this column”

This is because SQLUpdate_37 makes a change to the primary key of tblItems to change it from an INT to a BIG INT. This column is used by replication and as such, the table must be removed from the publisher as an “Article of Replication” first.

To upgrade if you see the above error:

1. Right-Click on the Publication, choose “Properties” and then choose “Articles”

   Open

   

2. Deselect the checkbox next to tblItems and click “OK”. You may see a popup stating this will invalidate the current snapshot. This is OK.

3. Follow the instructions on Upgrade an Existing ACM to update the publisher and subscriber databases.

4. Right-Click on the Publication again, choose Properties, then choose articles and make sure the checkbox “Show only checked articles in the list” is not selected.

5. Open

   

   Select the checkbox next to tblItems and click OK.

6. Right-click on the publication and select “View Snapshot Agent Status” and click “Start” to generate a new Snapshot prior to restoring replication.