SQL Server 2005 Tidbit 033

  • Article

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.