Database Stored Procedures

  • Article

The following is a list of Microsoft SQL Server stored procedures, which are organized by the table that they affect in the configuration database for Microsoft Windows SharePoint Services.

Warning  Modifying the database schema or database structures is not supported. 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.

Databases Table Stored Procedures

Name Description
proc_putDatabase Adds or updates a database record.
proc_getDatabaseById Returns a single database record.
proc_getDatabases Returns a set of database records.
proc_dropDatabase Deletes a database record.

Globals Table Stored Procedures

Name Description
proc_putGlobals Saves global settings.
proc_getGlobals Returns global settings.

Servers Table Stored Procedures

Name Description
proc_putServer Adds or updates a server record.
proc_getServerById Returns a single server record.
proc_getServers Returns a set of server records.
proc_dropServer Deletes a server record.

Services Table Stored Procedures

Name Description
proc_putService Adds or updates a service record.
proc_getServiceById Returns a single service record.
proc_getServicesByClass Returns a set of service records.
proc_dropService Deletes a service record.

Sites Table Stored Procedures

Name Description
proc_putSite Adds or updates a site record.
proc_getSiteById Returns a single site record.
proc_getSites Returns a set of site records.
proc_dropSite Deletes a site record.

VirtualServers Table Stored Procedures

Name Description
proc_putVirtualServer Adds or updates a virtual server record.
proc_getVirtualServerById Returns a single virtual server record.
proc_getVirtualServers Returns a set of virtual server records.
proc_dropVirtualServer Deletes a virtual server record.