Create database on local machine

I'm learning how to use MSSQL, I have SQL Enterprise Manager installed on my machine at work. I was also given access to the databases so I could start creating reports using Crystal Reports. (I have experience using MySQL and I just started this new job). What steps do I need to take to create a database on my local machine that I can use to practice? I'm going to be creating stored procedures that will run be the background of the report, and I would like to get some practice. Thanks!
horaliaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
YveauConnect With a Mentor Commented:
version 8 ? That means that you are running SQL 2000, not SQL 2008 ...

Anyway, yes your local machine can act as a SQL server as well, just install the SQL Server 2005 Express on your own machine. It's free and there is a SQL 2005 client as well (SQL Server Management Studio). Here is the home page for the SQL 2005 Express:
http://www.microsoft.com/sql/editions/express/default.mspx

You should be able to find the download links here.

Hope this helps ...
0
 
mfsamuelCommented:
Microsoft SQL Server 2005 Express Edition can be found here:
http://www.microsoft.com/downloads/details.aspx?FamilyID=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en

It will have almost everything you need to begin working with SQL Server.  This appears in the SQL Server 2008 zone, but is your company using 2008 for their production data already?

For your Crystal development SQL Server 2005 Express Edition should do all you need.

-Marc
0
 
horaliaAuthor Commented:
The Enterprise Manager and the SQL Query analyzer are both 8.0. I can see the databases that each server has, but I would like to create one on my desktop. Can my local machine run as a server too?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
horaliaAuthor Commented:
Exactly what I need. Thanks!
0
 
YveauCommented:
Glad I could be of any help and thanks for the grade !
0
 
mfsamuelCommented:
isn't that the same link I provided?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.