|
|
|
Поля TEXT при репликации
|
|||
|---|---|---|---|
|
#18+
Добрый день, при репликации MERGE после обновления UPDATETEXT не реплицируются поля типа TEXT. С чем это может быть связано ? При изменении любого другого поля репликация проходит нормально ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 25.09.2002, 19:26:52 |
|
||
|
Поля TEXT при репликации
|
|||
|---|---|---|---|
|
#18+
См. BOL: Planning for Merge Replication text and image Data Types in Merge Replication Merge replication supports the replication of text, ntext, and image columns only if they have been updated explicitly by an UPDATE statement because it causes a trigger to fire that updates meta data ensuring that the transaction gets propagated to other Subscribers. Using only the WRITETEXT and UPDATETEXT operations will not propagate the change to other sites. If your application uses WRITETEXT and UPDATETEXT to update the text or ntext columns, explicitly add a dummy UPDATE statement after the WRITETEXT or UPDATETEXT operations, within the same transaction, to fire the trigger and thereby guarantee that the change will be propagated to other sites. ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.09.2002, 10:10:51 |
|
||
|
|

start [/forum/topic.php?fid=46&fpage=3408&tid=1820064]: |
0ms |
get settings: |
9ms |
get forum list: |
19ms |
check forum access: |
3ms |
check topic access: |
3ms |
track hit: |
43ms |
get topic data: |
8ms |
get forum data: |
2ms |
get page messages: |
29ms |
get tp. blocked users: |
1ms |
| others: | 225ms |
| total: | 342ms |

| 0 / 0 |
