Whenever someone tells me that adopting their beliefs could give me the same type of life they have, I tell them that that's exactly what I'm afraid of.
—H. W. Kenton
Transactional replication is by far the most widely used form of SQL Server replication. It combines a good deal of functionality with reasonably simple configuration and administration. It's more full-featured than snapshot replication but much easier to set up and manage than merge replication.
One mistake I often see people make when deciding which type of replication to go with is not realizing that both snapshot replication and transactional replication offer immediate and queued updating subscriptions. People somehow get the idea that ...