question about transactional replication

  • hello i have a few questions, i currently have transactional replication for all my tables in my DB from server 1 to server 2.

    I need to alter a column in a few of the tables. I am planning to do this by just using an alter statement in management studio:

    example:

    begin tran

    alter table

    alter column 1 varchar(4)

    commit tran

    My question is what exactly are the steps, after i run each script to do the alters do i have to create a new snapshot and then sync?

    what about for ALTER TABLE DROP COLUMN statement?

  • http://technet.microsoft.com/en-us/library/ms151870(SQL.90).aspx

    this should help

    -------------------------------------------------
    -Amit
    Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]

  • exactly what i needed!!! thank you!!!

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

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