Table on Azure SQL is not usable anymore.

Question

Hi,

We have a table in Azure SQL which is not responding to any thing anymore.
Select, insert, and even truncate/drop do not provide any response.

The query runs for about 5 mins and than shows an error on

In SSMS it does not show an error, but also does not execute it. Query Editor on the portal shows above error. Any hints on how to resolve/overcome this ?

Answer 1

Hi Gertjan Oostrum •,

Welcome to Microsoft Q&A forum and thanks for using Azure Services.

As I understand, you are getting screenshot error upon execution of SQL query on a table.

-

Could you please let us know if other tables are working fine inside the same Database and schema in which this table belongs?

- How is the table formed? Check if there is indexing corruption on the table. Re-indexing the table should fix the problem.

- What type of SQL Query you are trying to execute?

Make sure if its some Stored Procedure, then you are not doing data type mismatch. Awaiting your inputs, thanks.