The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

Adding a column in MS SQL Server

on my production box hangs (query analyzer).  The table has about 25,000 rows, is indexed, and has no constraints, foreign key or otherwise.  I have let it go for about 20 minutes, then I cancel the statement out of fear that it is never going to complete.

any ideas?
Christopher Hester
Saturday, February 26, 2005
Do an sp_lock, or select from master..sysprocesses, while you're waiting for the operation to complete.
Dennis Forbes Send private email
Saturday, February 26, 2005
Thanks Dennis.  Sometimes the easiest things are elusive.  Thanks, and have a good evening.
Christopher Hester
Saturday, February 26, 2005

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
Powered by FogBugz