1

I am new to working with Microsoft SQL Server Management Studio, and it is not letting me drop a table that I have created. I need to modify its primary keys, but it freezes when I try to do that as well and when I try to save the file it freezes. I've run sp_who2'active' and it doesnt appear to have anything blocking it from being deleted or saved. Also tried running the command DROP TABLE and it ran for 2 minutes and didnt execute anything. Any help appreciated! Thank you!

saupton
  • 297
  • 2
  • 4
  • 9
  • Could be a problem with the disk. I can't say for sure, but at one point I set up a database on a bad disk of mine, and dropping tables, procedures and eventually the database took hours. – Xedni Feb 12 '15 at 04:14
  • 1
    Try TRUNCATE TABLE before dropping your table and compare the result. – sqluser Feb 12 '15 at 04:55
  • Thank you! I think I have a bad disk. – saupton Feb 17 '15 at 16:58
  • Make sure you check the "Drop Connections" box in the delete table dialog. – Yogi May 06 '18 at 02:19
  • In my case, this only happened with users who were not System Admins. You might need to adjust permissions both inside and outside of SQL – NadimAJ Feb 12 '21 at 16:39

0 Answers0