Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    Regular Coder
    Join Date
    Nov 2010
    Posts
    295
    Thanks
    105
    Thanked 0 Times in 0 Posts

    Starting off with SQL basics questions

    Hey guys, I am starting study SQL from here:

    http://www.tizag.com/sqlTutorial/sqldatabases.php

    I have installed SQL Server but stuck at :
    Code:
    SQL - Creating a Database
    
    Creating a database inside of SQL Express has its advantages. After launching Microsoft's SQL Server Management Studio Express application, simply right-clicking on the Databases folder of the Object Explorer gives you the option to create a New Database. After selecting the New Database... option, name your database "MyDatabase" and press "OK".
    First, si there supposed to be an icon for the server on my desktop? If so, none on my desktop. I looked in All Programs and am not seeing "Microsoft's SQL Server Management Studio Express"? Help please?

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,184
    Thanks
    75
    Thanked 4,340 Times in 4,306 Posts
    Management Studio is usually a separate download and install.

    Go back to the http://msdn.microsoft.com/express pages and see if you can't find where to download and install it from.

  • #3
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    SQL Server is a different RDBMS from MySQL. Please post questions for it in the general database forum.

  • #4
    Regular Coder
    Join Date
    Nov 2010
    Posts
    295
    Thanks
    105
    Thanked 0 Times in 0 Posts
    Since my pc is 32 bit, I had downloaded the first one on the top which is the "SQL Server Express 2008 R2", is this correct?
    Attached Thumbnails Attached Thumbnails Starting off with SQL basics questions-untitled.jpg  

  • #5
    Regular Coder
    Join Date
    Nov 2010
    Posts
    295
    Thanks
    105
    Thanked 0 Times in 0 Posts
    tried it from here

    http://www.microsoft.com/download/en...s.aspx?id=7593

    and tried to install 2 times but having a problem it seems the software will not restart the pc on it's own [see image attached] and when I do it manually nothing happens.

    Also, before doing so I choose the first option [see arrow] to install, is this correct? [see 2nd image]
    Attached Thumbnails Attached Thumbnails Starting off with SQL basics questions-untitled2.jpg   Starting off with SQL basics questions-untitled.jpg  

  • #6
    Regular Coder
    Join Date
    Nov 2010
    Posts
    295
    Thanks
    105
    Thanked 0 Times in 0 Posts
    I tried this one:

    SQL Server 2008 R2 Express
    32-bit Database and Management Tools


    and looks like it works!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •