Globals Table
The Globals table stores settings that apply across a Microsoft Windows SharePoint Services deployment.
Warning Modifying the database schema or database structures is unsupported.
Changes that you make to the database contents may be overwritten when you install updates or service packs for Windows SharePoint Services, or when you upgrade an installation to the next product version.
Columns
| Column name | Data type | Description |
|---|
| GlobalId | uniqueidentifier | Primary key. |
| SchemaVersion | nvarchar | Schema version of the configuration database. |
| UseHostHeader | bit | Hoster Header mode settings for Windows SharePoint Services. |
| UseNtAuthForDatabase | bit | 1 if Integrated Windows Authentication is being used for database access; 0 if SQL Authentication is being used.
|
| SmtpServiceId | uniqueidentifier | GUID for the Simple Mail Transfer Protocol (SMTP)
Service specified in the global settings of SharePoint Central Administration. Foreign key (Services table). |
| MailCodePage | int | Option selected for character set in the SMTP Settings specified in the global settings of Central Administration. |
| FromAddress | nvarchar | E-mail address identified in the From field of the SMTP settings specified in the global settings of SharePoint Central Administration. |
| ReplyToAddress | nvarchar | E-mail address that was placed in the Reply To field of the SMTP settings specified in the global settings of SharePoint Central Administration. |
| LastModified | datetime | Time of last modification to global settings record. |
| LastModifiedUser | nvarchar | User name of the person who last modified global settings record. |
| LastModifiedServer | nvarchar | Name of the server affected by the modifications. |
| Status | int | Not used in this table. |
| Version | timestamp | Version of the metainfo parameter in the table. This value is incremented when the UseHostHeader or SMTP Server Settings change. |
| Properties | ntext | Miscellaneous properties for the deployment. For example, this may include metadata such as HTML viewing settings, blocked file types. |