ALTER Column Question

• Panagiotis Grontas

  SSC Journeyman

  Points: 90

  More actions

  October 27, 2004 at 6:34 am

  #60471

  Greetings from Greece,

  I want to change the maximum size of a column with varchar datatype (from 1000 to 2000 characters). When I use the Enterpise Manager, the generated script recreates the table, storing the data in a temporary table etc.

  Why does this happen? I have tried to do that with the alter column statement and I observe no data loss.

  Is there any explanation?

  Thanks in advance

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  October 27, 2004 at 7:03 am

  #528148

  Well, let's say EM handles several things different than common sense would think. That's the way it is and it's by design 

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