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]
