spPageInfo

      CREATE PROCEDURE [dbo].[spPageInfo]
            (
                @ClientSitesID int,
                @PageID int,
                @TabID int
            )
            AS
            BEGIN

            select top 1
                [PageName],
                [Deleted]
            from
                dbo.vwSitePagesTab
            where
                [ID] = @PageID
                --and [ClientSitesID] = @ClientSitesID
                and [TabID] = @TabID

            END