Database Stored Procedures

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.