Web Table 1: Comparing Four Replication Methods
	Bidirectional Transactional	Transactional Queued	Transactional Immediate Updating	Merge
Supports offline data modification	Yes	Yes	No	Yes
Supports subscriber modification of text and image data	Yes	No	No	Yes
Uses triggers to track changes	No	Yes	Yes	Yes
Requires additional replication columns	No	Yes—a specifically named GUID column	Yes—a specifically named GUID column	Yes—a unique GUID column
Maintains transactional consistency	Yes	Yes	Yes	No—maintains a consistent flow of commands, not transactions (net result)
Supports conflict handling out of the box	No	Yes—very limited	Yes—conflict avoidance	Yes—exceptionally strong
Supports complex and dynamic filtering—for example, filtering by suser_sname()	No	No	No	Yes—exceptionally strong
Supports replication of stored procedure execution	Yes	No	No	No