Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Enhancements for Updatable Transactional Subscriptions

SQL Server 2005

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.

Community Additions

© 2015 Microsoft