Post reply

trying to increase the size of a replicated

  • March 12, 2007 at 10:08 am

    #172639

    Hi Everyone,

    I am trying to increase the size of a table from varchar 15 to varchar 30 and am getting an error, 'ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table 'dbo.PG_DrugTreatment' because it is being used for replication.'

    IS there any way to do it. Would really appreciate some help.

    Thanks

  • March 15, 2007 at 12:36 am

    #695146

    Hi,

        If it is the case where the table is being replicated, change the size of the column in the table in the replicated(child) table and then change the length in the parent table.

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

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