Obviously if we needed to run an initial snapshot in one of those circumstances then we could.
What if I stop replication, make the change to the field size on the publication db, then do the same on the subscriber db, changed the field sizes in the replication stored procs and then started...
Running an initial snap shot is not an option due to line limitations and the large amount of data involved.
Is there a stored procedure or something similar?
Oli.
I need to change the size of a column in one table from a char(15) to a char(25) in MS SQL 2000.
Sounds easy enough doesn't it?
However, the table is marked for replication and doesn't seem to want to have it's size changed.
Can anyone help on this issue? I have been looking everywhere for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.