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.