CODEWITHSUNDEEP
sqlsql-serverdatabasedatabase-design
Manish
Manish

Reputation: 6286

SQL: Create new database options explanation

When creating a new database in SQL SERVER, there are many options.

alt text

Can any of you guys please help me in understanding all these options?

Any explanation/links/help well appreciated.

Upvotes: 1

Views: 877

Answers (2)

Learning
Learning

Reputation: 8185

The db creation options and their significance is discribed here. This is for SQL server 2005, a link provides options for 2008 on the same page. Hope that helps.

Upvotes: 2

womp
womp

Reputation: 116977

The options are all documented on MSDN.

The documentation for CREATE DATABASE may shed some light on the immediate database options.

The documentation for SET lists all the database-level options that can be set.

Upvotes: 4

Related Questions