If you want to change a column in a table that is used for replication, you used to have to break replication to make the change, then re-enable it. Not any more. Schema changes are now replicated too. But if you make the change in SQL Server Management Studio, the generated change script drops and recreates the table, which wont work: you will need to alter the columns manually in SQL. Here is an example, where I change the nullability of a column from NOT NULL to NULL:
ALTER TABLE RA_Actual ALTER COLUMN WetDate smalldatetime NULL
Hopefully this will save you some time next time you need to make a minor modification to a replicated table.
Remember Me
a@href@title, i, strike, u
Copyright © 2003-2008 Falafel Software Inc.
Subscribe to Falafel Blogs
The opinions expressed herein are Falafel's employees own personal opinions and do not represent Falafel Software's view in any way in case they go bananas!