• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Step by step help on creating a local database in SQL Server 2005


Can anyone help me create a local server in SQL server 2005? I have SSMS express. I am trying to set up a local database so I can practice writing SQL queries.

1 Solution
Kumaraswamy RCommented:
Mark WillsTopic AdvisorCommented:
Well creating a local server means installing a local instance of SQL Server : http://technet.microsoft.com/en-us/library/ms143516(SQL.90).aspx

Now, you will need a license to do that, or, buy SQL Server Development Edition at a hugely reduced price (around $60 USD) and essentially the Enterprise Version, or, get the SQL Express with Advanced Services (contains all kinds of essential goodies) but with Express you do not get SQL Server Agent type goodies (like scheduled maintenance / backups, mail, mirroring and a few other bits). Express is also size constrained but it is free. Have a look at : http://technet.microsoft.com/en-us/library/ms365248(SQL.90).aspx and to install follow the steps in http://technet.microsoft.com/en-us/library/ms143441(SQL.90).aspx

So, first thing to do is to decide what version and then install the most appropriate for your needs. Also, if it is already installed, you could create a new registered server : http://msdn.microsoft.com/en-us/library/ms188231(SQL.90).aspx

Then to create a database, it is pretty much the same in all version - use SSMS interactively is probably the easiest - it will step you through there is a good tutorial on SSMS (Sql Server Management Studio) on : http://technet.microsoft.com/en-us/library/ms167593(SQL.90).aspx and to create a database have a read up on http://msdn.microsoft.com/en-us/library/ms175198(SQL.90).aspx  and if using SSMS then see: http://msdn.microsoft.com/en-us/library/ms186312(SQL.90).aspx

Now the most important thing is to make sure you install Books On Line - that can describe most things above for you, and if you are like me, will use it / refer to it fairly often.


Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now