Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
madhan
Yak Posting Veteran
59 Posts |
Posted - 2007-08-02 : 06:00:47
|
How to create a database in MS SQLserver 2005 express edition.Pleae help me to get started.I have learned some SQL commands.But i want to execute those in SQLserver 2005.But i don't know the procedure for creating a database.please help me on this. |
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-08-02 : 08:12:37
|
Read about CREATE DATABASE in sql server help fileMadhivananFailing to plan is Planning to fail |
|
|
madhan
Yak Posting Veteran
59 Posts |
Posted - 2007-08-02 : 10:53:00
|
Thanks for the reply madivannan. i have searched all over the sqlteam.com.but icouldn't find where to get the sql server help file.please help again. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-02 : 10:54:19
|
BOL = Books onlike = SQL Server help is what you get when you press F1 in Management Studio (2005) or Query Analyzer (2000)_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2007-08-02 : 11:14:19
|
[code]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 ][/code]Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2007-08-03 : 14:58:02
|
How about right-clicking on "Databases" in the left TreeView and choosing "New Database..."? |
|
|
|
|
|