Lia Nungaray
asked on
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!
ASKER
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Exactly what I need. Thanks!
Glad I could be of any help and thanks for the grade !
isn't that the same link I provided?
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