May 7, 2003 at 9:00 am
I am trying to change data type from varchar (10) to (20)
on a table that is in transactional replication but this column is not part of the subscription.
SQL 2000 SP3
Any help will be appreciated.
May 12, 2003 at 8:00 am
This was removed by the editor as SPAM
May 12, 2003 at 9:09 am
Just do the alter, it don't affect replication. If the column was published, you'd have to drop the subscription and remove the column from the article, change it, add back, redo the subscription including snapshot.
Andy
May 15, 2003 at 2:56 pm
Andy,
you wrote : "If the column was published,[...] you'd have to [..] remove the column from the article...".
I've followed your instructions but it didn't work : remove the column from the article is not enough ; I had to remove the table from the publication... and it worked after snapshot !
Thanks.
Jacques.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply