Services Table

The Services table stores records for services used by the 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
ServiceId	uniqueidentifier	Primary key.
ClassId	uniqueidentifier	GUID that indicates the service type such as database, Simple Mail Transfer Protocol (SMTP), or Web service. Web service corresponds to a virtual server in Microsoft Internet Information Services (IIS).
ServerId	uniqueidentifier	Associated server. Foreign key (Servers table).
Instance	nvarchar	Instance name of the service where a service such as the database service supports additional named instances.
LastModified	datetime	Time of the last modification to the service record.
LastModifiedUser	nvarchar	User name of the person who last modified the service 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 a service changes.
Properties	ntext	Not used in this table.