Every time I try to install Microsoft SQL Sever management studio I face the problem as its very difficult to find out where to install this option from SQL Server Installation Center from Start menu. So I feel some of you might also have faced this. Here are the steps to install SQL Server Management Studio Express in Windows 7 and I am almost sure this works for the Windows Vista as well.
Download the Microsoft SQL Server 2008 R2 RTM - Management Studio Express from below linkhttp://www.microsoft.com/downloads/en/details.aspx?familyId=56AD557C-03E6-4369-9C1D-E81B33D8026B&hash=pu2KqQlVhNSChOWEy5kjipZ3tJAjOUAGotQj7cJxreHsvoWk6ssvhigfIqP7rWxNRzzZHsHsHHmO4I6dNuUFtw%3d%3d
Double click the downloaded file and select "New installation or add features to an existing installation" from the "Installation" tab.
Follow the steps and select "Management basics" or something similar from the steps and when asked to choose the features to install. It may take few moment to install and when done, look at the "Microsoft Sql Server 2008 R2" folder from Start menu.
Hope this will help someone.