locked
regarding sql server RRS feed

  • Question

  • User442781244 posted

    Hi

    I am using vs2010 ultimate. I have to install Sql server. i think it comes with vs 2010. please tell me where i will get sql in vs and how to install it.

    Monday, April 1, 2013 12:19 PM

Answers

All replies

  • User-183374066 posted

    You can install MS SQL SERVER EXPRESS 2008 R2 from following links

    http://blogs.msdn.com/b/petersad/archive/2009/11/13/how-to-install-sql-server-2008-r2-express-edition-november-ctp.aspx

    http://social.technet.microsoft.com/wiki/contents/articles/993.install-sql-server-2008-r2-express.aspx

    If you don't have Management tools installed than go for "Database and Management Tools"

    Regards.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 1, 2013 12:30 PM
  • User442781244 posted

    i have vs2010 installed on my pc. but i am not getting how to open sqlserver as everyone is telling that it comes with vs. 

    Monday, April 1, 2013 12:41 PM
  • User1508394307 posted

    SQL Server Express 2008 comes with VS2010. If you installed the full version of VS2010, then SQL should be installed on your machine, too. The SQL Server Management Studio (IDE) doesn't come with Visual Studio 2010 installation, only the database engine does. So, if you want to manage the installed database instance from without the Visual Studio 2010 IDE you'll need to download the management studio seperately and install it. 

    On this page http://www.microsoft.com/en-us/download/details.aspx?id=7593 you'll find the download link for SSMSE.

    To work without SSMS go to Visual Studio, 'Tools->Connect to Database'.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 1, 2013 12:49 PM
  • User442781244 posted

    hi

    Smirnov

    I have to simply use t-sql .writing query and execute it. So tell me what to do? 

    Monday, April 1, 2013 12:56 PM
  • User1508394307 posted

    You can start with using VS.NET. Go to Tools-Connect to Database, it would most likely show the Add Connection window where you have to specify what server you want to connect. It is most likely named as "machinename\SQLEXPRESS" where machinename is your computer name. You can also simply click on Refresh to get the available servers. After name is specified you can click on Test Connection to ensure that it is working well. Once you get an confirmation, click on OK to close the Add Connection window and you will see your server at the right hand Server Explorer panel. Right click on server name, New Query. And now you can write and execute queries against your server.

    http://msdn.microsoft.com/en-us/library/ms165037(v=vs.80).aspx
    http://msdn.microsoft.com/en-us/library/vstudio/ms171886(v=vs.100).aspx

    I personally prefer to use SSMS, which would require additional setup as mentioned in my previous post above.

    Monday, April 1, 2013 1:47 PM
  • User442781244 posted

    Hi

    smirnov

    I am following sqlexpress idea rt now.

    Monday, April 1, 2013 1:56 PM
  • User442781244 posted

    hi

    smirnov..

    from your link i have installed the SSMSE.....now what to select...after connect to DB...this is giving a more option. which option i should select???

    after this tell me step by step what to do????

    Monday, April 1, 2013 2:09 PM
  • User1508394307 posted

    Did you on Connect to Database Engine window? What do you mean by "this is giving a more option"?

    Monday, April 1, 2013 2:22 PM
  • User442781244 posted

    database engine...choose data source...i selected sql server then add connection window  opened.

    Monday, April 1, 2013 2:26 PM
  • User1508394307 posted

    Click on Refresh button to get the available servers. If it does not find your server, try to enter "machinename\SQLEXPRESS" where machinename is your computer name. You can find it when clicking on Start - Computer - Computer Name. SQLEXPRESS is an instance name,  it could be also different than this one. Then click Test Connection.

    http://msdn.microsoft.com/en-us/library/ms165037(v=vs.80).aspx

    Monday, April 1, 2013 2:51 PM