Quick post: "The Visual Studio component cache is out of date. Please restart Visual Studio.". Got this error when I tried to run a query on a DB in SQL Server Management Studio 2016. There is discussion on possible causes here, but that's about it.
There are a couple fixes for it.
Choose one of the following:
Solution 1: Restart Management Studio.
- Close SQL Server Management Studio.
- This should automatically clear temp files related to Management Studio.
- Optional: Open Task Manager and stop all Visual Studio tasks.
- Start SQL Server Management Studio.
- Attempt query again.
Solution 2: Delete the Management Studio temp folder.
- Close SQL Server Management Studio.
- Browse to C:\Users\YourUserName\AppData\Local\Temp\
- Browse to SSMS folder.
- Delete folder and contents.
- Start SQL Server Management Studio.
- Attempt query again.
Solution 3: Lastly, you can try running the Disk Cleanup Utility.
- Close SQL Server Management Studio.
- Search for Disk Cleanup Utility.
- Open Disk Cleanup Utility.
- Select Temporary Files only.
- Click OK, Delete files.
- Start SQL Server Management Studio.
- Attempt query again.
One of the above should work for you. :-)
DISCLAIMER: As stated, I’m not an expert so please, PLEASE feel free to politely correct or comment as you see fit. Your feedback is always welcomed. :-)
