can not modify the table.

• Noman Tariq

  SSCommitted

  Points: 1750

  More actions

  March 11, 2006 at 9:09 am

  #89658

  Hi All,

  I have a problem, I have restored a backup of the publisher's Database. but when i go for modify or add in a table it gives me an error:

  "Unable to modify table.

  cannot add columns to the table because it is being published for merge replication. "

  What is the solution of this error. please help me out.

  Thanx.

• Noman Tariq

  SSCommitted

  Points: 1750

  More actions

  March 11, 2006 at 11:50 am

  #626139

  Thanx to u all,

  Actually i have found the solution... that is:

  -----------------

  update sysobjects

  set replinfo = 0

  where replinfo = 128

  and xtype = 'U'

  ------------------