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:

Delete Subscription
Delete Publication
Add the new column
Create Publication
Create Push Subscription
Run SnapShot

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.

Thanks, Dave