SQL: Create new database options explanation

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

Can any of you guys 开发者_开发问答please help me in understanding all these options?

Any explanation/links/help well appreciated.

---

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.

---

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.