Cannot drop index from Azure database

Question

We got the issue that we cannot drop the index in azure database (the database is on Elastic pool) by running the below in SSMS:

DROP INDEX [nci_wi_FactInvoiceDetail_145BA2082F925FB3C62800F00A3ECF41] 
ON [SPENDBY].[FactInvoiceDetail]

We got timeout exception.

This index was created automatically using Automatic Tuning option from Azure Portal before this option was turned off on server level:

Any ideas for this issue?

Shiraz Bhaiji · Accepted Answer · 2020-10-20 20:36:55Z

1

It may be that you are getting a timeout since the index is in use.

You could try disabling the index before you delete it.

answered Oct 20, 2020 at 20:36

Shiraz Bhaiji

65.7k37 gold badges149 silver badges260 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

That's correct, we found there is running query on the background running for a long time