The datatype changed on the publisher, but did not replicate to subscribers after I started the snapshot agent.

Any suggetsions?

Ali baba_SQLNew Member

23 Jul 2004 11:01 AM

that's what I tried to use it for : transactional repl.the distribution agent failed, snapshot said no articles available for replication. meanwhile, there was a new schema change.

Ali baba_SQLNew Member

23 Jul 2004 06:08 PM

well, you can drop and add a column, but this will delete all the data in that column. Moreover, it will recreate the that column at the end of the existing columns (append it).

what if you need it to be in specific pplace (say 3rd column)What if you need to change the datatype on the column that has data, and you don't want to loose the data. I know you can delete all subscribtions + publications, do your changes and recreate and repush all publications again, but is there a better way?