[thelist] Adding a Column in EM is Taking WAY TOO long.

[Ken Schaefer]

----- Original Message ----- 
From: "Anthony Baratta" <Anthony at Baratta.com>
To: <thelist at lists.evolt.org>
Sent: Wednesday, November 05, 2003 11:13 AM
Subject: Re: [thelist] Adding a Column in EM is Taking WAY TOO long.


: At 02:58 PM 11/4/2003, Rob Smith wrote:
: >Hi list,
: >
: >I'm using Enterprise manager to add a column (Design Table > save) to an
: >existing table of around 70k rows. After waiting around for 20 minutes
for
: >the operation to complete, I gave up.
: >
: >Has anyone had experience like this they can share? advice to offer?
: >alternate quicker methods (ALTER TABLE)?
:
: You can view the SQL used to make your changes and run that in Query
: Analyzer. You probably lost your connection to the Server during the
: process or you have a ton of indexes impacted by your changes.
:
: Basically with table changes, EM makes a new table with the new table
: structure and does an insert from olde table to new table, creates all the
: constraints and indexes, drops the olde table and then renames the new
: table the old name.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

That depends, IIRC, on the recovery mode of your database (simple,
bulk-logged, full)

Cheers
Ken

Microsoft MVP - Windows Server (IIS)