its all on the job. I have opened a fair number of
incidents with PSS, so I get to pick their brains.
I also get teched and PDC presentations on replication on
cassetts from mobiltape.com. You can get recent
presentations from
http://microsoft.sitestream.com. Answering questions also helps me to understand the
product as well.
[quoted text, click to view] >-----Original Message-----
>Hillary,
>
>Do you do a lot with replication that I see your name a
lot out here ? Im
>really impressed and keep up the good work. How have you
trained yourself in
>replication ?
>
>
>"Hilary Cotter" <hilaryK@att.net> wrote in message
>news:02cf01c39cc0$d68fad60$a301280a@phx.gbl...
>> Yes, you are correct. You can update text and image
>> fields with no worries, although you may have to adjust
>> the 'max text repl size' parameter for the size of your
>> text or image rows. Use sp_configure to do this.
>> >-----Original Message-----
>> >I am trying to understand something I read in
>> >
>> >Want to replicate several OLTPish databases from 2000
to
>> >2000. I assume I want transaction replication. I trying
>> to
>> >understand one of the consiferations regarding text
>> >fields. I have read the following on technet:
>> >
>> >INSERT, UPDATE, and DELETE statements at the Publisher
on
>> >text and image columns are supported with no special
>> >considerations. However, these columns cannot be
updated
>> >by Subscribers that use snapshot replication or
>> >transactional replication and immediate updating or
>> queued
>> >updating subscriptions.
>> >
>> >
>> >What does "without consideration" mean. The subscriber
>> >will not be performing updates. Does that mean that I
can
>> >replicate without any special consideration or do I
need
>> >to rewrite all the stored procs that write and update
the
>> >text fields?
>> >
>> >Len Bearse
>> >
>> >.
>> >
>
>
>.
