Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Server 2005 table not dropping
I did try to truncate first but after 3 hours of waiting I stopped it and tried to drop the table. All in all, I finally rebooted the server and was then able to drop the table. Go figure. Thanks for reponding.- rmjohnson
- Post #4
- Forum: Microsoft SQL Server: Setup and Administration
-
SQL Server 2005 table not dropping
I have been trying to drop a table for a while but it will not drop. It is not a large table. The command I used is: drop table tablename I also tried truncating the table: truncate table tablename Both appear to be running but never complete. I have started deleting records in groups but...- rmjohnson
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Setup and Administration
