| frostbb 2006-01-19, 8:23 pm |
| We've found that Sql Server 2005 SMS "Modify Table option" 'croaks' when
trying to insert a startcard_nbr INT column into the following table just
above the last_updt_date column. It throws an error window with the
following ...
-----------------------------------------
Post-Save Notifications
! Errors were encountered during the save process. Some dtabase object were
not saved.
'wl_startcard_image'
table
- Unable to modify table.
Timeout expired. The timeout period elapsed prior to completion of the
operation or the server is not responding.
---------------------------------------
The table contains approximately 52,000 records with a .pdf image in the
image column for each record (about 13.5G of disk space)
We can SUCCESSFULLY run the actual Sql Script that the "Modify Table" action
creates in the Query Analyzer. Takes about 25 minutes. The script creates
a temp table with the new column, uses insert into to move the data from
the original data across, drops the original table and renames the temp
table.
Is there some type of Time Limit on the SMS Table Modify Functions or is the
clicky pointy interface simply limited to smaller "more normal" alter table
operations ??
Just curious.
Barry
in Oregon
== BEFORE ==
CREATE TABLE dbo. Tmp_wl_startcard_ima
ge
(
sc_image_id int NOT NULL IDENTITY (1, 1),
sc_image image NULL,
last_updt_date datetime NULL,
last_updt_userid varchar(20) NULL,
rec_creation_date datetime NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
== AFTER ==
CREATE TABLE dbo. Tmp_wl_startcard_ima
ge
(
sc_image_id int NOT NULL IDENTITY (1, 1),
startcard_nbr int NULL,
sc_image image NULL,
last_updt_date datetime NULL,
last_updt_userid varchar(20) NULL,
rec_creation_date datetime NULL
) ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
When I try to update the table SMS Query Analyzer running on the server
console pauses for about 30 seconds and then returns an error window with
the following information ...
|