Here's the standard way to do it:
1. unsubscribe the article
2. drop the article from the publication
3. make the table change
4. create the article in the publication
5. subscribe the article

However, there is also a proc called sp_repladdcolumn which will let you
tack on a column to the table without taking it out of replication.

-----Original Message-----
From: Graham Macaskill
[mailto:mssqldba-ezmlmshield-x52567906.[Email address protected]
Sent: Wednesday, June 30, 2004 6:46 AM
To: LazyDBA Discussion
Subject: changing schema of replicated DB's


Hi All

I need to make changes to the schema of a database that's being
replicated.
When the table is changed, I get the message "Cannot drop the table
'dbo.Messages' because it is being used for replication."

Is there a shortcut or do I have to drop all publications and recreate
them after completing the change?

Thanks


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page