Replication in SQL Server 2000

• Robbinsbk

  Grasshopper

  Points: 10

  More actions

  May 5, 2009 at 2:53 pm

  #133779

  I would like to increase the length of a varchar field in a table that is being used in Replication. However, I get an error message:

  ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'dbo.Note' because it is being used for replication.

  Is there away to update the table without dropping the replication publication and readding it?

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  May 6, 2009 at 5:33 am

  #989436

  If I remember correct, SQL 2000 only supports adding and deleting of columns on a replicated table, but not changing an existing table. See also http://msdn.microsoft.com/en-us/library/aa237127(SQL.80).aspx

  So if you want to change the length of a varchar column you must first remove the publication.

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