If for any unfathomable reason you find that the SQL Server Management Studio is missing from your start menu, don’t be afraid! It’s easy as creating a new shortcut on the desktop and moving it back – you just have to know the location of the correct .exe file. And the location of where to move it to. This second part can be a bit tricky with the latest versions of windows (i can’t even imagine how Windows 8 Server will be without the start menu), so let’s make life a little easier and share the default file locations, shall we?
"C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
Start menu for "All Users" location (on Windows 2008 R2):
C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft SQL Server 2008 R2
Start menu for specific user:
If you put the shortcut on YOUR start menu, it will go to your user folder. Please be kind and put it in the “All Users” start menu location. Why is it located on c:\ProgramData instead of c:\users\AllUsers ? Well, thats one of the unfathomable things, like the reason that the original shortcut is missing in the first place.