SQL Server/T-SQL/Database/Database Option

ANSI null default - "True" ensures SQL Server follows the SQL 92 rules to see if a column can allow NULL values

1>
2> --ANSI null default - "True" ensures SQL Server follows the SQL 92 rules to see if a column can allow NULL values.
3>
4> CREATE DATABASE myDatabase
5> EXEC sp_dboption "myDatabase", "ANSI null default", "False"
6> GO
1>
2> Drop database myDatabase
3> GO
1>

autoclose: "True" ensures that the resources are cleared when the last user logs off

1>
2> --autoclose: "True" ensures that the resources are cleared when the last user logs off.
3>
4> CREATE DATABASE myDatabase
5>
6> EXEC sp_dboption "myDatabase", "autoclose", "True"
7> GO
1>
2> Drop database myDatabase
3> GO

autoshrink: "True" indicates this database can be shrunk in size safely

1> --autoshrink: "True" indicates this database can be shrunk in size safely.
2> CREATE DATABASE myDatabase;
3> EXEC sp_dboption "myDatabase", "autoshrink", "False"
4> GO
1>
2> Drop database myDatabase
3> GO
1>

dbo use: "True" means that only the user ID that created the database has access and can use the database. Any other ID will be refused

1> --dbo use: "True" means that only the user ID that created the database has access and can use the database. Any other ID will be refused.
2>
3> CREATE DATABASE myDatabase
4> EXEC sp_dboption "myDatabase", "dbo use", "False"
5> GO
1>
2> Drop database myDatabase
3> GO
1>

quoted identifier - "True" ensure only single quotes are allowed when using this database

1>
2> -- quoted identifier - "True" ensure only single quotes are allowed when using this database.
3>
4> --By setting this to OFF, you can delimit a string by either a single quote or a double quote.
5>
6> CREATE DATABASE myDatabase;
7>
8> EXEC sp_dboption "myDatabase", "quoted identifier", "True"
9> GO
1>
2> Drop database myDatabase
3> GO

read only: "True" ensures no modifications to the data can be made. Only data reads are allowed

1> --read only: "True" ensures no modifications to the data can be made. Only data reads are allowed.
2>
3> CREATE DATABASE myDatabase
4> EXEC sp_dboption "myDatabase", "read only", "False"
5> GO
1>
2> Drop database myDatabase
3> GO
1>

single: "True" ensures only one user has access to the database at a time. Any subsequent users will be refused

1> --single: "True" ensures only one user has access to the database at a time. Any subsequent users will be refused.
2>
3> CREATE DATABASE myDatabase
4> EXEC sp_dboption "myDatabase", "single", "False"
5> GO
1>
2> Drop database myDatabase
3> GO
1>