Post reply

Alter article schema that are being used in the replication

  • December 22, 2008 at 2:38 am

    #383620

    Hi All,

    We are using Transactional Replication for the data Sync. and now we need to alter the table schema for some articles i.e. we need to add columns in the middle of the table. So, on adding the column the SQL Server is throwing an error like this

    "Cannot drop the table 'dbo.TableName' because it is being used for replication."

    . Cud u please suggest me the best way to add the columns in tables that are being used in the replication?

    Thanks in Advance.

    Regds,

    Anil.M

  • December 22, 2008 at 2:59 am

    #916018

    How are you altering the table?

    You should be able to add new columns by using the ALTER command inTSQL. But you cannot use the table designer in SSMS because that does try to drop and recreate the table.

    See also http://msdn.microsoft.com/en-us/library/ms151870(SQL.90).aspx

    [font="Verdana"]Markus Bohse[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply