My name is HarshDeep Singh, and I am a SQL Server engineer with Microsoft CSS. I've been working on SQL Server for quite some time, and the intention behind starting this blog is to try and share my knowledge with the SQL Server community. Any feedback or suggestions on the blog are both welcome and solicited. Please feel free to drop me a line on firstname.lastname@example.org anytime.
Okay, let me admit first up that this is not an out and out SQL Server issue, but one of those interesting ones, that required me to provide an easy workaround. What happened was, someone (or some program) deleted the entire SQL Server folder from the start menu. All the components were, however, still installed and were functioning perfectly.
I actually went to the following path (this was a SQL 2008)
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\binn\VSShell\Common7\IDE
and was able to find the ssms.exe there, using which SQL Server Management Studio started perfectly.
So the question was, how do we get the shortcuts back? Here are the steps:-
And voila, all your shortcuts are back. Cool one, isn’t it?
P.S. Please note that this only works if the installation paths are the same for both the machines involved (which they mostly are for Tools and Workstation Components).