CODEWITHSUNDEEP
azureazure-sql-database
Jamie Dixon
Jamie Dixon

Reputation: 4282

Azure Truncate table

I recently spun up a sql database on Windows Azure. I created a couple of tables and loaded some data. I then went into Sql Server Management Studio on my local machine and typed

Truncate table XXXX

And now it is clocking "Executing Query". Is truncate not supported by azure?

Upvotes: 0

Views: 5177

Answers (1)

Jamie Dixon
Jamie Dixon

Reputation: 4282

Tony:

I think you are right. I used the suggestion here and after resizing the db, all of the connections went away and I could truncate without a problem.

Thanks

Upvotes: 0

Related Questions