CREATE PROCEDURE [dbo].[PromoteSnapshotInfo]
@SnapshotDataID as uniqueidentifier,
@IsPermanentSnapshot as bit,
@PageCount as int,
@HasDocMap as bit
AS
IF @IsPermanentSnapshot = 1
BEGIN
   UPDATE SnapshotData SET PageCount = @PageCount, HasDocMap = @HasDocMap
   WHERE SnapshotDataID = @SnapshotDataID
END ELSE BEGIN
   UPDATE [ReportServerTempDB].dbo.SnapshotData SET PageCount = @PageCount, HasDocMap = @HasDocMap
   WHERE SnapshotDataID = @SnapshotDataID
END      

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