Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2005 creating sql databases

Posted on 2009-05-18
6
Medium Priority
?
147 Views
Last Modified: 2012-05-07
what free version of SQL server 2000/2005/2008 will allow me to create a sql database from scratch, thank you.
0
Comment
Question by:systems_ax
  • 3
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24413763
The SQL Server MSDE /EXPRESS editions will do it
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 2000 total points
ID: 24413853
0
 
LVL 1

Author Comment

by:systems_ax
ID: 24413955
do I need database services or client components?
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 60

Expert Comment

by:chapmandew
ID: 24414003
both.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 24414010
you need to install the database services because it is the database functionality, but you also want the client components so that you can interact with the database....the client components is the GUI tool.
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24414044
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

824 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question