Post reply

How to change data type

  • May 7, 2003 at 9:00 am

    #81896

    I am trying to change data type from varchar (10) to (20)

    on a table that is in transactional replication but this column is not part of the subscription.

    SQL 2000 SP3

    Any help will be appreciated.

  • May 12, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • May 12, 2003 at 9:09 am

    #456850

    Just do the alter, it don't affect replication. If the column was published, you'd have to drop the subscription and remove the column from the article, change it, add back, redo the subscription including snapshot.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • May 15, 2003 at 2:56 pm

    #457363

    Andy,

    you wrote : "If the column was published,[...] you'd have to [..] remove the column from the article...".

    I've followed your instructions but it didn't work : remove the column from the article is not enough ; I had to remove the table from the publication... and it worked after snapshot !

    Thanks.

    Jacques.

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

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