Record Size Limitation

• kaliyappan_k

  Valued Member

  Points: 59

  More actions

  January 2, 2004 at 1:06 am

  #83279

  I have to create a table that has to store a record of more than 8000 bytes, but SQL Serve warns me that some of the data may be lost, when the record size exceeds the said no of bytes, but creates the table. What is the workaround for this problem, so that i can store more than 8000 bytes of data in a record.

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  January 2, 2004 at 1:09 am

  #488442

  You can use TEXT which can hold upto 3GB of data.

  Cheers,

  Crispin

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  January 2, 2004 at 1:51 am

  #488447

  For general information this might be useful http://www.sqlservercentral.com/columnists/sjones/pagesize.asp

  Frank

  http://www.insidesql.de

  http://www.familienzirkus.de

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

• jxflagg

  Hall of Fame

  Points: 3817

  More actions

  January 2, 2004 at 12:59 pm

  #488514

  What is the structure of your table?