CODEWITHSUNDEEP
sql-serverazureazure-sql-database
robsta
robsta

Reputation: 426

Azure Database cannot query table

I have a database hosted on Azure that have 50 or so tables. There is one table with around 25 columns and 100,000 that I cannot query. I can't even query a single record, SQL Management Studio just shows the query running constantly.

I can query all of the other tables and permissions are OK.

Any Ideas on how I can troubleshoot?

Upvotes: 1

Views: 505

Answers (1)

robsta
robsta

Reputation: 426

To resolve I thought I'd create a copy of the database to see if the copy had the same issue. Before making the copy, I made my production database Read Only.

After making the production database readonly, I could then query again. I then made my production database readwrite and that seem to resolve it.

I hope this helps someone.

Upvotes: 2

Related Questions