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 »
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 »
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.