Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
efinkelb
Starting Member
4 Posts |
 Posted - 2007-11-30 : 13:52:19
|
| Hi everyone. I have a field that is image datatype. That table is included in a snapshot replication. When I try to update that field - on the publication server, which is the same as distributor server - if the image is too big (in size), an error message appears. When I try to update with images that has less size it works. If I take out the subscriptions, it works for every image size.Any ideas? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-02 : 01:11:59
|
| What was the error? |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-12-03 : 04:38:22
|
| change the value 'max text repl size (B)' from sp_configure, this limits the size of a replicated column. |
|
|
|
efinkelb
Starting Member
4 Posts |
Posted - 2007-12-03 : 10:08:45
|
| Hi, thanks for your answers, I have tried that, but that didn´t work. As fas as I know, that works for transactional replication, and in my scenario we are talking about snapshot replication. Regarding the error message, it just says the field can not be updated. |
|
|
|
|
|
|
Can not update a replicated image datatype field