CODEWITHSUNDEEP
sqlsql-serverazureazure-sql-database
cuongle
cuongle

Reputation: 75306

Cannot drop index from Azure database

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:

enter image description here

Any ideas for this issue?

Upvotes: 0

Views: 551

Answers (1)

Shiraz Bhaiji
Shiraz Bhaiji

Reputation: 65371

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.

https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-index-transact-sql?view=sql-server-ver15

Upvotes: 1

Related Questions