Drop Column causes error

• peter sala

  Grasshopper

  Points: 12

  More actions

  November 18, 2004 at 7:19 pm

  #163924

  Hi all,

  I have a table with 4 million rows and about 60 columns

  I want to drop a couple of columns.

  When I tried it hours and a message (which was accidently cleared) stating something like the the PRIMARY FILEGROUP is full.

  Basically I wan't to know if I can drop these columns without updating nay transaction logs.

  Thanks

  Peter

   

   

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 19, 2004 at 3:58 am

  #530786

  Could it be you've tried this via Enterprise Manager?

  If so, you might want to have a look at ALTER TABLE blahblah DROP COLUMN. The syntax is explained in BOL.

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