Change schema on SQL Server 7 Replication

Last Post 08 Apr 2004 06:57 AM by cchitanu. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
cchitanu
New Member
New Member

--
07 Apr 2004 09:53 AM
Hi,
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 ?)

Thanks

cchitanu
New Member
New Member

--
08 Apr 2004 06:57 AM
Do you have a link for SQL Server 7 BOL ?(I can find only SQL Server 2000)
Thanks
You are not authorized to post a reply.

Acceptable Use Policy