SQL Replication and locked databases

• Awake2-690499

  Grasshopper

  Points: 17

  More actions

  March 27, 2008 at 7:12 am

  #379431

  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?

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  March 27, 2008 at 11:30 am

  #794773

  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]