visual studio code 2019 hang when tryint o save sql file

As soon as I click the red button to stop the application from running, SSMS returns to normal operational speed. After some quick testing, it appears that SSMS drags when Visual Studio is actively running a local web application that uses the local SQL Server database the app is using. As soon as I stopped that, SSMS would immediately return results. Then by chance I noticed that my Visual Studio 2019 (v16.67.6) was actively running a local web application project.

I searched and found others with similar issues but none of the resolutions worked for me. For example, running a query or attempting to modify an existing stored procedure would take up to a minute or more to appear. Hopefully you will never experience this situation, but if you do you now have a way to get back into your database project.I recently noticed that my local development copy of SQL Server Manager Studio (SSMS, v.1) would sometime run very slowly and other times seemed just fine. Once I opened the project back up, everything was working fine and I was back in business! I looked in the root directory of the project and the. I decided to close the database project and rename the.

One other clue that something had happened to this file was that when doing database schema compares, an error message about a cache identifier not existing was being displayed. dbml file is to cache the model in order to help speed up opening and building the project. In a database project, the model is persisted in a. Luckily in my case, I decided to look at the project files a little bit closer to see if possibly one them was the culprit. Some people had gotten so frustrated that they ended up going to the extreme of reinstalling Visual Studio. After doing a few web searches, I still wasn’t finding anything that would help solve the problem.

The first thing I tried was closing Visual Studio and restarting, but the error still persisted. Hopefully the following will same you some time and frustration. It caused me some down time before discovering what was causing the issue. This happened to me for the first time recently. ‍It is normal to see this from time to time, but it isn’t normal for the message to constantly be displayed and for your database project to be unresponsive. Your database projects will be ready after # operations are completed.' Have you ever received the following message when trying to open a Visual Studio database project?

Visual studio code 2019 hang when tryint o save sql file