Home Forums SQL Server 2005 Business Intelligence renamed ReportServerTEMPDB now errors referencing dbo.executioncache RE: renamed ReportServerTEMPDB now errors referencing dbo.executioncache

  • Just realised, mine is 2008 which we are moving from a named instance to the default instance on the other machine, and thought we might rename the databases, but here's the list of sp's where it occurs

    AddPersistedStream

    AddReportToCache

    CheckSessionLock

    CleanBrokenSnapshots

    CleanExpiredCache

    CleanExpiredSessions

    CleanOrphanedSnapshots

    ClearSessionSnapshot

    CopyChunks

    CopyChunksOfType

    CopyChunksOfType

    CreateChunkAndGetPointer

    CreateChunkSegment

    CreateNewSnapshotVersion

    CreateSegmentedChunk

    CreateSession

    DecreaseTransientSnapshotRefcount

    DeepCopySegment

    DeleteExpiredPersistedStreams

    DeleteObject

    DeleteOneChunk

    DeletePersistedStream

    DeletePersistedStreams

    DeleteSnapshotAndChunks

    DereferenceSessionSnapshot

    FlushReportFromCache

    GetChunkInformation

    GetChunkPointerAndLength

    GetFirstPortionPersistedStream

    GetNextPortionPersistedStream

    GetReportForExecution

    GetSessionData

    GetSessionData

    GetSnapshotChunks

    GetSnapshotPromotedInfo

    IncreaseTransientSnapshotRefcount

    InsertUnreferencedSnapshot

    IsSegmentedChunk

    LockPersistedStream

    LockSnapshotForUpgrade

    MarkSnapshotAsDependentOnUser

    OpenSegmentedChunk

    PromoteSnapshotInfo

    ReadChunkPortion

    ReadChunkSegment

    RemoveReportFromSession

    RemoveSegment

    RemoveSegmentedMapping

    RemoveSegmentedMapping

    SetPersistedStreamError

    SetSessionCredentials

    SetSessionData

    SetSessionParameters

    SetSnapshotChunksVersion

    SetSnapshotProcessingFlags

    ShallowCopyChunk

    TempChunkExists

    UpdateSnapshotPaginationInfo

    UpdateSnapshotReferences

    WriteChunkPortion

    WriteChunkSegment

    WriteFirstPortionPersistedStream

    WriteLockSession

    WriteNextPortionPersistedStream