SQL Server 2005 Tidbit 033

Data Storage?

The following question was asked at a Recent “Best of SQL Server 2005 Launch” TechNet Event in Kansas City (Overland Park Kansas, actually.  Had a lovely time there, thank you!  …and although it was a bit of a dive, the Karaoke at the Red Balloon was a lot of fun!)

“I heard somewhere that you now can replicate some table schema changes during replication.  Is this true?”

Yes indeed!  From the Books Online:…

If you make the following schema changes to a published article, they are propagated, by default, to Microsoft SQL Server Subscribers:

  • ALTER TABLE
  • ALTER VIEW
  • ALTER PROCEDURE
  • ALTER FUNCTION
  • ALTER TRIGGER


You can use replication stored procedures to specify whether these schema changes are replicated. The stored procedure that you use depends on the type of publication.

The full books online article is found HERE.

(NOTE: You’ll need to have SQL Server 2005 Books Online installed for that link to work.  I highly recommend it!  It’s FREE!)

Got an IT question?  Give me a comment, or contact me.