I've a transactional replica scenario which basically has one pubblication (with some table) and a lot of subscriptions. All is working fine from some months. Now I've to alter a column of one of the replicated table: now it is a varchar(40) and it will
be varchar(500). When I try to execute the sql script to alter that column I receive an error because the column is replicated. I think I've to drop all subscriptions, alter the column, rebuild the subscriptions. Is there a fast way?
Thank you all
View Complete Post