"UpdatePortalInfo" Stored Procedure

Description:

This stored procedure is used by the Site Settings administration page to set the portal's display name, and whether the edit button should alway be shown for all modules in the portal.

Definition:

    CREATE PROCEDURE UpdatePortalInfo
    (
        @PortalID           int,
        @PortalName         nvarchar(50),
        @AlwaysShowEditButton bit 
    )
    AS

    UPDATE
        Portals

    SET
        PortalName = @PortalName,
        AlwaysShowEditButton = @AlwaysShowEditButton

    WHERE
        PortalID = @PortalID
        
Database Tables Used:

Portals:  The portals table holds site-level settings.  The primary key in this table is the PortalID identity field.