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.
+3
A:
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.
womp
2010-01-27 07:14:25
Thanks for the link...I did saw it before posting the question but I'm still not sure if all of the options (shown in the image above) have been explained.. :-(
Manish
2010-01-27 07:17:21
They're all in there - mostly in the documentation for SET. Remember that anything you can do in the management interface, you can do with a Transact-SQL statement.
womp
2010-01-27 07:18:38
GREAT ADVICE WOMP ... :-) ...THANKS...
Manish
2010-01-27 07:32:26
+1
A:
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.
Learning
2010-01-27 07:15:31
Exactly what I needed... BTW what did you searched for to reach that link? ;-)
Manish
2010-01-27 07:19:49