• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 666
  • Last Modified:

SQL replication subscriber cannot update text or ntext?

Hi all,

im getting this error
System.Data.SqlClient.SqlException (0x80131904): Updatable subscriptions: The text, ntext, or image values inserted at the Subscriber will be NULL.

after some searching, ive come across some things saying subscribers cant update text ntext or image?
i think we use text a few times for large edits

is there a work around/different options for this?
we need to replicate text of greater length then 255 chars you see

Thanks
0
awilderbeast
Asked:
awilderbeast
  • 2
1 Solution
 
mozculluCommented:
varchar(max), nvarchar(max),varbinary(max) can be used as replacements for these data types.
0
 
awilderbeastAuthor Commented:
does varchar max exceed 255 chars?
0
 
mozculluCommented:
varchar(max) is the replacement for text field in newer versions of SQL. Sure it exceeds.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now