How can i change my Table Structure that is replicated?
I need to add a new field.
In SQL Server 2005 you can use alter table syntax to add/remove/change columns in a replicated table. Check out the following link for more information -- http://msdn2.microsoft.com/en-us/library/ms151870.aspx
If you are using SQL 2000, you are limited to the functionality of sp_repladdcolumn and sp_repldropcolumn. SQL Server 2000 Books Online will give you more information on the syntax of these procs.
Hope this helps,
Tom
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment