Unanswered: Problem adding NOT NULL column to Replication
I'm new to replication and am trying to determine how to add a NOT NULL column, with no default value, to a replicated table. Can someone tell me the steps I need to take. The only way I have been able to successfully alter the table is as follows:
Add the new column
Create Push Subscription
I know I am missing something. I can't believe I need to run SnapShot and resend the entire database for one column change. If we were a 24x7 shop replicating a 100+ GB database, the downtime during the snapshot process would be unacceptable.