How to Store Large amount of Data into Sql Server 2000 table

• Deepak Kumar Garg

  Newbie

  Points: 6

  More actions

  February 12, 2009 at 2:26 am

  #77255

  Hi All,

  I have to store large amount of data into sql server 2000 table. I am using ntext type for this but it is storing only 8K of data. I have also set the TEXTSIZE to 2GB but still not able to store whole of the data. My data size is about 80k. I have checked in sql server documentation that ntext can store upto 2GB of data.

  If any one has done this ever before pls help me.

  Thanks & Regards,

  Deepak

• J-440512

  SSCertifiable

  Points: 6285

  More actions

  February 13, 2009 at 9:07 am

  #943708

  There is a similar discussion at

  h[font="Courier New"]ttp://www.sqlservercentral.com/Forums/Topic655509-8-1.aspx[/font]

  I was going to ask if you really need unicode character set (ntext) but if you are storing sanskrit characters then ntext would be justifed.

  Regards

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  February 13, 2009 at 9:16 am

  #943715

  Why do you think it is only storing 8K of data?