thanks for the tips, i'll give it a go later
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! ---------------------------------------------------------------------- ---------------------------------------------------------------------- Gordon Thomas <GThomas@Chann To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> el4.co.uk> cc: Subject: RE: [ cf-dev ] ALTER Table 02/14/03 12:15 PM Please respond to dev Sounds like something has a lock on one of the rows on the table and isn't letting go for the Alter statement... Have you tried disconnecting all your applications from that datasource and then trying to run it? If you have and it still doesn't work, sounds like an issue with your install/data. Gordon Thomas Interactive Services Channel Four Television [EMAIL PROTECTED] Tel +44 (0) 20 7306 8278 Mob +44 (0) 79 6850 2066 Pag +44 (0) 76 9323 2458 http://www.channel4.com -----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] Any views or opinions are solely those of the author and do not necessarily represent those of Channel Four Television Corporation unless specifically stated. This email and any files transmitted are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error, please notify [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]
