Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a SQL Server 2005 database that uses merge replication to sync to SQL Compact Edition subscriptions. We added a column to a table using:


The SQL CE subscriptions will not sync, giving this error:

Alter table only allows columns to be added which can contain null values.

We figured out that the MSDN docs are in error, and that we should have used sp_repladdcolumn. But now we are trying to fix the sync problem. We have reinitialized all subscriptions and generated a new snapshot, but we still get the same sync error.

What are we missing?

share|improve this question

migrated from Feb 6 '12 at 18:16

This question came from our site for system and network administrators.

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.