about 20 minutes, i decided it wasn't going to happen so stopped the query.
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- Paolo Piponi <[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> o.uk> cc: Subject: RE: [ cf-dev ] ALTER Table 02/14/03 11:58 AM Please respond to dev Works fine for me when I test. How long do you leave it hanging? I've worked in the past on a table with 1.5 million records and it took more than 5 minutes. Paolo -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 14 February 2003 11:38 To: [EMAIL PROTECTED] Subject: [ cf-dev ] ALTER Table Using SQL Server 7, trying to add a new column to a table. Doing it in either Enterprise Manager or the Query Analyzer has the same result, it never seems to complete, and just hangs. The Task Manager shows the server is still Running, not Not Responding, and it's not using up hardly any memory. In Query Analyzer, using SQL something like: ALTER TABLE properties ADD uniqueid varchar(255) null Ran for quite a while (minutes), and nothing happening. there's about 31,000 rows in the table. I'm assuming this is a symptom of a bigger problem with SQL Server; if so what is it and how do i fix it? And for adding this column, the solution seems to be create a new table, which has all the original columns and the new column, then copy the data into the new table, drop the old table and rename the new table. unless anyone's got a better idea. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
