March 27, 2008 at 7:12 am
Hi all,
I am trying to determine the best way to be able to modify the table structure of a database that is being replicated. While the db is published whenever I try to modify the db it tells me it is locked. The only way I can unlock it is to delete the publication. Is there any way I can just stop the replication and unlock the db?
March 27, 2008 at 11:30 am
There are some limited modifications that you can make to the table definitions through the Replication Management interfaces (GUI & sys Procs), however, for the most part you will have to remove replication from the table, make your changes and then re-add the table to replication again.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply