Results 1 to 2 of 2

Thread: Replication - TEXT field

  1. #1
    Hoang Guest

    Replication - TEXT field

    I have a table that has a TEXT field and I want to replicate it. It already has a primary key field in it. I read that in SQL Server 6.5, you can do transactional replication on a table that has a TEXT field in it. I'm wondering if I need to do any other special configuration to replicate this table, i.e. enable the truncate on checkpoint option or anything else? Thanks, Hoang

  2. #2
    patrick fediere Guest

    Replication - TEXT field (reply)

    Hi, Hoang,

    You could try a vertical selection of columns on the table containing the 'text column'.
    By vertical selection I mean that you select only the column wanted.
    I use that for other purpose than Text datatype and it's ok.
    Try and inform us about text datatype.
    Thanks
    Patrick

    On 12/30/98 8:06:21 AM, Hoang wrote:
    > I have a table that has a TEXT field and I want to replicate it. It
    > already has a primary key field in it. I read that in SQL Server 6.5, you
    > can do transactional replication on a table that has a TEXT field in it.
    > I'm wondering if I need to do any other special configuration to
    > replicate this table, i.e. enable the truncate on checkpoint option or
    > anything else? Thanks, Hoang

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •