Stored procedures used with shared tables

This topic lists and briefly describes the most important stored procedures used in conjunction with shared tables.

GetMasterSiteSp

When given a site name, this stored procedure finds the intranet for that site and returns the master site from the intranet record for that site.

IntranetProcessSharedTablesSp

This stored procedure puts a new shared table configuration in place for the intranet when the user clicks Process on the Intranet Shared Tables form. Input parameters include the intranet name and table name.

IntranetProcessSharedUserTablesSp

This stored procedure handles setting up shared user tables or per-site user tables for the specified non-master site and the master site on the specified intranet. This stored procedure takes two input parameters, the intranet name and the name of a non-master site on the intranet. This stored procedure gets called for every non-master site on the intranet.

IntranetRemoteScriptSp

This stored procedure allows a script to be run at the using site in an intranet with shared tables. This stored procedure is used by other stored procedures.

IntranetValMasterSiteLinksSp

This stored procedure validates live link setup between the master site and the using sites of an intranet. Input parameters include the intranet name and the master site name.

RecreateUsingSiteViewSp

When given an intranet name, this stored procedure gets the master site from the intranet record, and then gets the master site’s Database Name value, executes IntranetValMasterSiteLinksSp, finds any shared _all tables at the master site, drops the same _all table in the using site, and recreates in using sites a view to the _all table at the master site.

ResetIntranetSharedUserTablesFromDefaultSp

This stored procedure removes all records from the IntranetSharedUserTable table and populates it with records from IntranetSharedUserTableDefault.

UpdateMasterSiteAllTableSp

This stored procedure updates a master site's _all table with records from a using site in an intranet with shared tables. Input parameters include the master site and the table name.

UserNamesRemoteUpdateSp

This stored procedure adds code to verify that the UserNames table exists in the current site. If not, it returns and does nothing.