jhedfsdyer9
03-15-2011, 12:05 PM
,nike Woods on Course to Become the World’s Richest Sportsman_6918 (http://www.happywa.com/bbs/read.php?tid=1092194),down jacket moncler (http://www.jacketshoponline.org/)
Create Database in Sql Server 2005,asics tigers Coping With Dementia_1078 (http://www.xp-dev.com/sc/browse/69359/user_blog.php), Database Statements
Following is the full syntax used for creating database in Sql Server 2005.
-------------------------------------------------------------------------------------------------------------------------------------------
CREATE DATABASE database_name
[ ON [ PRIMARY ]? [ <? filespec >] ]
{ LOG ON [ < filespec > ] ]
< filespec > : : =
( [ NAME = logical_file_name , ]
FILENAME = 'os_file_name'
[ , SIZE = size ]
[ ,abercrombie sweatshirt (http://www.abercrombiefithstore.org/specials.html),canada goose down parka Feel the Magical Power of Cosmetic Dentistry_1315 (http://web.59lyren.com/forum.php?mod=viewthread&tid=274431&extra=), MAXSIZE = UNLIMITED ]
[ ,asic gel shoes (http://www.asicsshoesale.com/products_new.html), FILEGROWTH = growth_increment ] ) [ ,.... n ]
Description ::-
ON specifies the disk file used to store the data portion of the database.
LOG ON specifies the disk files used to store log files.
FILENAME=os_file_name specifies the operating-system file name for the file.
PRIMARY specifies the associated <filespec> list that defines files in the primary filegroup.
NAME=logical_file_name specifies the logical name for the file.
MAXSIZE=max_size specifies the maxium size to which the file defined in the <filespec> list can grow.
FILEGROWTH=growth_increment specifies the growth increment of the file defined in the <filespec> list.
Remember - " FILEGROWTH setting for a file cannot exceed the MAXSIZE setting"
NOTE : Everything written between [ ] is optional .
But remeber that to create a database you must be a member of the dbcreator server role.
After a database is created, to check details of the database use following command :
sp_helpdb [ database_name ]
To drop a user defined database use following command:
DROP DATABASE database_name
Note: you cannot delete a system-defined database.
To rename a user-defined database use :
sp_renamedb old_database_name , new_database_name
Fortunately you can also create a database by a right click on the object explorer, Thanks to SQL SERVER Management studio 2005.
SQL SERVER 2005 contains the following system database :
master
tempdb
model
msdb
Resource
--------------------------------------------------------------------------------------------------------------------------------------------
If u have any query feel free to ask. If u like this post , rate & comment it.
Regards,
Anuj Tripathi
Create Database in Sql Server 2005,asics tigers Coping With Dementia_1078 (http://www.xp-dev.com/sc/browse/69359/user_blog.php), Database Statements
Following is the full syntax used for creating database in Sql Server 2005.
-------------------------------------------------------------------------------------------------------------------------------------------
CREATE DATABASE database_name
[ ON [ PRIMARY ]? [ <? filespec >] ]
{ LOG ON [ < filespec > ] ]
< filespec > : : =
( [ NAME = logical_file_name , ]
FILENAME = 'os_file_name'
[ , SIZE = size ]
[ ,abercrombie sweatshirt (http://www.abercrombiefithstore.org/specials.html),canada goose down parka Feel the Magical Power of Cosmetic Dentistry_1315 (http://web.59lyren.com/forum.php?mod=viewthread&tid=274431&extra=), MAXSIZE = UNLIMITED ]
[ ,asic gel shoes (http://www.asicsshoesale.com/products_new.html), FILEGROWTH = growth_increment ] ) [ ,.... n ]
Description ::-
ON specifies the disk file used to store the data portion of the database.
LOG ON specifies the disk files used to store log files.
FILENAME=os_file_name specifies the operating-system file name for the file.
PRIMARY specifies the associated <filespec> list that defines files in the primary filegroup.
NAME=logical_file_name specifies the logical name for the file.
MAXSIZE=max_size specifies the maxium size to which the file defined in the <filespec> list can grow.
FILEGROWTH=growth_increment specifies the growth increment of the file defined in the <filespec> list.
Remember - " FILEGROWTH setting for a file cannot exceed the MAXSIZE setting"
NOTE : Everything written between [ ] is optional .
But remeber that to create a database you must be a member of the dbcreator server role.
After a database is created, to check details of the database use following command :
sp_helpdb [ database_name ]
To drop a user defined database use following command:
DROP DATABASE database_name
Note: you cannot delete a system-defined database.
To rename a user-defined database use :
sp_renamedb old_database_name , new_database_name
Fortunately you can also create a database by a right click on the object explorer, Thanks to SQL SERVER Management studio 2005.
SQL SERVER 2005 contains the following system database :
master
tempdb
model
msdb
Resource
--------------------------------------------------------------------------------------------------------------------------------------------
If u have any query feel free to ask. If u like this post , rate & comment it.
Regards,
Anuj Tripathi