Home Forums SQL Server 7,2000 Administration Strategies for bypassing the 8,060 byte limit on Row Length RE: Strategies for bypassing the 8,060 byte limit on Row Length

  • Gail and Lynn,

    Thanks for your advice. Today, I went and created a test table with one ntext column and was able to insert 38 million characters ... it took 4 minutes for the insert, but it did it. I was surprised.

    Would either of you know what BOL is talking about when it says that for SS2K, the max row length is 8060 bytes? I clearly saw that by using ntext, I could go way beyond that.

    Thanks,

    Tom