I am having trouble replicating tables in several databases that house large text columns. I used sp_configure to set "max text repl size" to the its maximum size and I still have troubles. We are thinking in changing from transactional replication to merge replication which tolerate better txt data type. Any suggestions? Answers? Thanks
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Replicating Text, Images and Ntext
- Thread starter pulsar6
- Start date
royjimenez
Programmer
hi!
U have to do an UPDATE more for this fields.
UPDATE table
SET FIELD = FIELD
where....
In the help there's more details.
I hope that it helps.
Regards.
The life is too short to cry and long enough to try it... God bless us.
![[thumbsup2]](/data/assets/smilies/thumbsup2.gif "[thumbsup2] [thumbsup2]")
U have to do an UPDATE more for this fields.
UPDATE table
SET FIELD = FIELD
where....
In the help there's more details.
I hope that it helps.
Regards.
The life is too short to cry and long enough to try it... God bless us.
- Status
Similar threads
- Locked
- Question
- Locked
- Question