August 27, 2004 at 6:36 am
Hi need modify a field on the table but it is using for replication and sql don't let me do it, unless
i drop the replication, any way to work around that?
thanks
August 27, 2004 at 8:07 am
If you want to change an existing column you have to remove replication. If you want to add a column or drop a column SQL2000 has two store procedure sp_repladdcolumn and sp_repldropcolumn which allow you to so without removing the replication.
M
[font="Verdana"]Markus Bohse[/font]
August 27, 2004 at 8:12 am
There are ways to do it, some easier than others depending on the version of SQL you have. If you look at the list of articles I've publishered there are two on the subject, for for SQL 7 and for SQL2K - title starts with "altering replicated". Look that over, if you've got questions after that I'll be glad to help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply