A client working with a web application which is no longer supported needed to extract critical information from their database. The function to do this was not available within the software. I was given access to the server. Surveyed the database structure, then ran the queries to pull the data needed. All data exported to .cvs files.
You may this issue if Visual Studio was installed on your machine prior to SQL Server 2008 R2.
To manually add Management Studio, visit: http://www.microsoft.com/en-us/download/details.aspx?id=7593
If the link has changed, search download Management Studio for Express 2008 r2 on your favorite search engine.
Once downloaded, run and follow the instructions for new installation. Under the features option you will see Management Studio as an option. Check the box and continue the installation.