Post reply

increaase the size of a column in a replicated table

  • March 12, 2007 at 2:10 pm

    #175635

    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 12, 2007 at 5:17 pm

    #694540

    There is no easy way to do this...

    Read the following article to get the solution....

    http://www.sqlservercentral.com/columnists/pibison/alteringacolumnonareplicatedtable.asp

     

    MohammedU
    Microsoft SQL Server MVP

  • March 15, 2007 at 11:54 am

    #695315

    Thank you very much for the reply.

    I do have one more question.

    I have to change the schema of three tables which are replicated. Just tell me if i am wrong.

    I am planning to drop the subscription and then just drop these three articles (, , ) and make the necessary changes and then again add these three articles , , and then add the subscription.

    Will this process work or am i missing any step.

  • March 18, 2007 at 7:36 pm

    #695625

    We have to do this a lot (the clients always chasing changes) and we never drop subscription (there's way to much data over slow connections).  We use the second method in the link mentioned above.  It is a little limiting as you can only set the type and size but any defaults etc can be handled in other ways.

Viewing 4 posts - 1 through 3 (of 3 total)

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