I have a database hosted in server, there is 2 issues I am facing.
My web application is getting the error "Execution Timeout expired" occasionally, Its for a simple delete query. Some times it will work just fine, some times this error will popup.
Other issue is, after I restore that database to my local system I will not able to open "NEW QUERY" in management studio. When I click "New Query" the login prompt for "SQL Management Studio" will be shown. After clicking login, sometimes it will open the "New Query", Some times it wont.
Please help me.
Image of login prompt attached
![112386-1.png][2] [2]: /answers/storage/attachments/112386-1.png

