Link to home
Start Free TrialLog in
Avatar of eviglotti
eviglotti

asked on

Alter or drop table failing on MS SQL 2012

I have a table that has over 100 columns, though isn't the widest table I have. However, anytime I use MS SQL Management Studio to try to modify the table by adding a new column, it crashes SQL management studio. Likewise even if I try to "drop table xxxx", the query hangs forever.  It seems to be the only table in this database and the table has only about 200 records. All nightly data integrity checks come out ok. What else should I try to be able to either drop or alter this table?
ASKER CERTIFIED SOLUTION
Avatar of Jagdish Devaku
Jagdish Devaku

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial