SQL 2008 r2 Installation

Question

Hi,

I have installed Visual studio 2010 yesterday on windows 7 home basic.

With studio installation it installed some SQL packages.

But i don't see management studio for SQL where i can write and execute SQL development queries.

Do i need to install something else to get this feature on my machine?

Any help is appreciated.

Thanks,

Dpkas

Answer 1

Hi Dpkas,

Install Sql Server Management Studio from below link.

http://www.microsoft.com/download/en/details.aspx?id=22985 

Regards

Kayden

Answer 2

Hi dpkas, do you have SQL 2008 R2 installed on your system as well? If you don't, you can follow KaydenSmith's advice.

At the same time, you can also access the "Data sources" window by clicking "Data" from the menu inside VS 2010, and then clicking on "Add New Data Source...". Follow the steps to add the new data source, and once you have added the data source, you will be able to see it in the "Data sources" window.

From there, you can actually add new table adapters or data tables which allow you to create and execute SQL queries. This can be accessed by right-clicking on the data table/table adapter, and selecting the Configure option.