Studio management 2014
This is becoming insanely frustrating and completely random. We cannot work anymore on the SQL because any small action we do will lock SSMS and will force us to end task.
In the middle of the work a popup appears: "SSMS is waiting for an operation to complete. bla bla bla" with two options: SWITCH TO and CONTINUE WAITING.
None of them does anything, not clear which operation is it talking about.
This happens when trying to open a table, a view or even pasting into a query window. When typing the query manually it doesn't happen! Ending task and reopening the SMSS will immediately result in the same.
We tried to:
- Restart SQL server
- Right clicking in the taskbar (Someone suggested that)
- Using SSMS from another network computer
- Running select * from sys.sysprocesses where blocked<>0. there were no results.
Because of point 3 we assume that the problem is not in the SSMS, but in the SQL instance?
Last time it was resolved by itself, the next time I connected after a day. Please help, we wasted hours here.
Thanks
2条答案
按热度按时间whlutmcx1#
I think that ending task of RDPclip on the remote computer solved the issue.
I will see when this happens again if doing it resolving it.
niknxzdl2#
I'm new to using SQL server and had queries saved in OneDrive. When I tried accessing them I got the same pop up and had to end the OneDrive task in task manager. I just save everything locally now.