Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: Increase columns width of merge replicated table

    We are using merge replication and it is working fine. We are looking for increase in on numeric column 10,5 instead of 7,2. How I can do it?

    Any suggession highly appreciated by us.


  2. #2
    Join Date
    Jan 2004
    North Carolina
    I have only been able to accomplish this by copying out the data and the rowguid for each record, sp_repldropcolumn the old column, sp_repladdcolumn'ing it back in, and copying the data back in. (might not have sproc names exactly right)

    I remember reading about a builtin sproc that you could execute that would run certain commands on a database or table that was in replication, but I can't find it's name, and I don't know it's limitations.

Posting Permissions

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