Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

How to create database in sql server 2005. How to start with sql server 2005.

share|improve this question

migrated from stackoverflow.com Mar 13 '10 at 12:55

This question came from our site for professional and enthusiast programmers.

closed as not a real question by Nick Kavadias, Darth Satan, Sam, splattne Mar 14 '10 at 8:06

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

3  
How about reading a book? Browsing to Microsoft and read up on SQL Server 2005? –  marc_s Mar 13 '10 at 8:18
1  
    
Instead of actually having to learn SQL Server 2005, you might want to consider outsourcing whatever problem you have to someone else. –  Ville Koskinen Mar 13 '10 at 8:28
1  
@Ville: he outsourced it to us. –  John Saunders Mar 13 '10 at 8:34
    
Or: msdn.microsoft.com/SQLServer for developers –  marc_s Mar 13 '10 at 8:41

2 Answers 2

right click on databases in object explorer. then New Databse. and if you are a beginer , you should learn more about databases at first. start with a book if you know about databases as marc_s noticed!

share|improve this answer

you can make it by script or by wizard in SQL Server.

from msdn :

CREATE DATABASE database_name [ ON [ < filespec > [ ,...n ] ] [ , < filegroup > [ ,...n ] ] ] [ LOG ON { < filespec > [ ,...n ] } ] [ COLLATE collation_name ] [ FOR LOAD | FOR ATTACH ]

< filespec > ::=

[ PRIMARY ] ( [ NAME = logical_file_name , ] FILENAME = 'os_file_name' [ , SIZE = size ] [ , MAXSIZE = { max_size | UNLIMITED } ] [ , FILEGROWTH = growth_increment ] ) [ ,...n ]

< filegroup > ::=

FILEGROUP filegroup_name < filespec > [ ,...n ]

share|improve this answer