MS SQL Basics Tutorial: Database property settings

After you create a database, you can also set its properties to change some of the settings at the time of creation and properties that cannot be set at creation time. The Database Properties Settings dialog box, shown in Figure 6-4, appears when you right-click the database where you want to set the properties and select option Properties from the shortcut menu.

In the General page box, you can see property information such as the status of the database, owner, creation time, capacity, backup, maintenance, and so on.

In the Data files and Transaction log page boxes, you can see a dialog box similar to Figure 6-2 and figure 6-3, where you can reassign properties such as the name, storage location, and initial capacity size of the database file and transaction log files as you would when you created the database.

In the Filegroups page box, as shown in Figure 6-5, you can add or remove filegroups, but if there are files in the filegroup that cannot be deleted, you must first move the files out of the filegroup.

In the Options page box, you can set many of the database's properties, as shown in Figure 6-6. The option selected in Figure 6-6 is the system defaults to TRUE.

Each option is selected with the following meanings:

Restrict Access

Access control. Member of Db_owner;dbcreator,or sysadmin

Only the database owner, the database creator, and the system administrator have permission to use the database. Single User

The database can only be used by one user at a time. Read only

The database is read-only and can be viewed without modification. ANSI Null Default

Allows you to enter a null value in the column of the database. Recursive triggers