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. |