SQL Server 2005 Tidbit 033
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.
