Post reply

msrepl_tran_version column problem

  • August 27, 2009 at 3:16 am

    #209978

    Hi All

    When i migrated my SQL 2000 to SQk 2005, i have tried to create a replication on some tables, it doesn't seems to work well for for me, so i stopped replication and deleted all publishers and subscribers, and migrated using log shipping, now i am been left with some tables with column names "msrepl_tran_version", can i drop this column, will there be any impact by dropping this columns, i am just going to drop this columns using alter table drop column command, Please suggest

    Thanks

  • August 27, 2009 at 4:29 am

    #1045409

    You should be fine to drop the columns, however you will probably find that the triggers associated with merge replication are still on the table as well so you will need to drop them first.

  • August 27, 2009 at 5:51 am

    #1045448

    thanks Magic 🙂

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

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