I'm unable to drop a table on Sql Azure. Previously I cancelled a query that involves this table, because takes to long on execute. Maybe other procedure is blocking me.
How can I solve this problem on Sql Azure?
Thanks.
Asked
Active
Viewed 2,193 times
5
-
What message do you get when try to drop the table? – Igor Borisenko Sep 23 '12 at 10:12
-
1Maybe the query was still executing when you tried to drop the table, even though you cancelled it on the client. As Igor said, post the full conversation (your command and the reply you got). – Fernando Correia Sep 23 '12 at 14:40
-
1I got an execution time expired error. I was able to drop the table after one day. – eicruzado Sep 23 '12 at 19:22
-
2But I still dont know how to force close current connection on Sql Azure, so the question is open. – eicruzado Sep 23 '12 at 19:25
-
3To terminate an executing process you can use the Kill statement as answered in http://stackoverflow.com/a/1092567/376366 – Fernando Correia Sep 24 '12 at 13:18
1 Answers
0
Try Restarting and Apply:
IF EXISTS (SELECT * FROM [tablename]) DROP TABLE [tablename]
mrbitzilla
- 368
- 3
- 11