Globals Table

  • Article

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.