spLoadDefaultSitePage

                CREATE PROCEDURE spLoadDefaultSitePage
(
    @ClientSitesID int
)
AS
    declare @PageID int

    /*Get default page for portal */

    SELECT 
        @Pageid = defaultPageId
        FROM
            ClientSites
        WHERE
            ID=@ClientSitesID

    exec spLoadRecord_SitePages @PageID