Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    100

    Question Unanswered: Changing field length whilst replicating

    Hi

    I have two databases that are merged using replication, and I want to change the length of one of the fields. Can anyone think of a way of doing it that doesn't require dropping the whole publication and rebuilding it? Thanks Ed

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Changing field length whilst replicating

    You don't have to drop the entire publication. You have two options, one is to drop the subscription and the article to change the DDL and add the subscription then intialize it. The other is to use sp_repldropcolumn and sp_repladdcolumn to drop the old column and add it back with the length you want without dropping the subscription and the article. Of course, you need to save the data somewhere to add it backup in when the new column got recreated.

  3. #3
    Join Date
    Jul 2003
    Posts
    100

    Smile Brill

    Brilliant, Thanks Ed

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •