August 26, 2009 at 10:13 am
hello i have a few questions, i currently have transactional replication for all my tables in my DB from server 1 to server 2.
I need to alter a column in a few of the tables. I am planning to do this by just using an alter statement in management studio:
example:
begin tran
alter table
alter column 1 varchar(4)
commit tran
My question is what exactly are the steps, after i run each script to do the alters do i have to create a new snapshot and then sync?
what about for ALTER TABLE DROP COLUMN statement?
August 26, 2009 at 10:58 am
http://technet.microsoft.com/en-us/library/ms151870(SQL.90).aspx
this should help
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 26, 2009 at 11:51 am
exactly what i needed!!! thank you!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply