In order to change a column for a table involved in replication(SQL Server 7) I need to delete the subscriber, delete the publication, change the table, re-create the publication and re-create the subscriber.
I also can use ...Generate SQL script... to script the steps to delete and re-create the publication.
Do you know if I can use these scripts to perform the next steps :
1. delete the publication(is this deleting the subscriber too ?)
2. change the table
3. create the publication(is this creating the subscriber too ?)