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.