Monthly Archives: June 2020

Cannot Find One or More Components. Please Reinstall the Application

By | June 28, 2020

Recently i faced below problem while opening SQL Server Management Studio [SSMS], after trying multiple things finally it started working, Solution – Go to Control panel -> uninstall programs and search for Shell. [In my case its 2015, it may depend on different versions on our system.]   3. Right click and choose to repaire.… Read More »

How to Create drop down list of cell in excel

By | June 27, 2020

Steps: Enter name in each row of excel, for which you want to create list, e.g. as below, 2. Go to Data tab in excel sheet and click on data validations as highlighted below, 3. In data validation pop-up, Select list from allow dropdown and Select source =$B$5:$B$9 [rows of values for which you want… Read More »

The Visual Studio component cache is out of date, Please restart Visual Studio – SSMS

By | June 14, 2020

This is not frequent error but yes we may face such error while connecting to ssms. The Visual Studio component cache is out of date, Please restart Visual Studio. Solution, clear temp files & run disk clean up for c drive. make sure you select temporary files. try reconnecting to ssms again, it will connect.