June 2015
Intermediate to advanced
1800 pages
70h 6m
English
You can access many of the most common database options via the Options page of the Database Properties dialog. To get to this dialog, you right-click a database in the SSMS Object Explorer and select Properties. When the dialog appears, you select the Options page from the list on the left side of the Database Properties dialog. Figure 20.4 shows the Options page for the AdventureWorks2012 database. The options listed under Other Options can be listed alphabetically or by category. The default display mode is by category.
FIGURE 20.4 Database options in SSMS.
The default settings for these options suffice for most installations. ...
Read now
Unlock full access