how to increase size of datatype

• asif mustak bhura

  Right there with Babe

  Points: 761

  More actions

  July 15, 2006 at 2:12 am

  #75012

  Dear

  I am using sql server 2000,

  I have used varchar datatype in table.but It provides 8000 character maximum.

  but i want more than that.

  Please help me out

  best regards,

  ASIF

• Zubeyir

  SSCrazy

  Points: 2559

  More actions

  July 15, 2006 at 2:06 pm

  #649414

  then use text or ntext

• asif mustak bhura

  Right there with Babe

  Points: 761

  More actions

  July 16, 2006 at 12:18 am

  #649425

  Dear Sir,

  Please show me with example i tried but i couldnt succeed.

  waiting for reply.

• Zubeyir

  SSCrazy

  Points: 2559

  More actions

  July 16, 2006 at 2:21 am

  #649428

  CREATE TABLE Test
  (
  IDINT,
  MtTextTEXT
  )