Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to alter a column tha is being published

Author  Topic 

venkath
Posting Yak Master

202 Posts

Posted - 2007-02-05 : 09:23:07
Hi all

I have put transactional replication on my database..now i want to
alter a column in a table that is being published for the replicaion..

How can i alter a table that is being published for replication..

for ex..

alter table country alter column country_name nvarchar(30)

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-02-06 : 02:11:39
There is no direct way to do this... it is easy to add or remove column but not modify...

Altering a column on a Replicated Table
http://www.replicationanswers.com/AddColumn.asp


MohammedU
Go to Top of Page
   

- Advertisement -