Enhancements for Updatable Transactional Subscriptions

In SQL Server 2000, immediate and queued updating Subscribers did not allow updates to any of the large data types (text, ntext, and image). In SQL Server 2005, the addition of varchar(max) and varbinary(max) data types, and the fact that the data types will be manifested in triggers, allows transactional updating Subscribers to support updates to large data types. No special options are required to take advantage of this functionality.

See Also

Concepts

Replication Enhancements

Other Resources

Updatable Subscriptions for Transactional Replication

Help and Information

Getting SQL Server 2005 Assistance