CREATE PROCEDURE [dbo].[GetSnapshotPromotedInfo]
@SnapshotDataID as uniqueidentifier,
@IsPermanentSnapshot as bit
AS
IF @IsPermanentSnapshot = 1
BEGIN
   SELECT PageCount, HasDocMap
   FROM SnapshotData
   WHERE SnapshotDataID = @SnapshotDataID
END ELSE BEGIN
   SELECT PageCount, HasDocMap
   FROM [ReportServerTempDB].dbo.SnapshotData
   WHERE SnapshotDataID = @SnapshotDataID
END      

GO
GRANT EXECUTE ON  [dbo].[GetSnapshotPromotedInfo] TO [RSExecRole]
GO