locked
Potential Bug: RRS feed

  • Question

  • When cleaning up our SqlServer database I found that some of the system center stored procedures don't drop their temp tables. Here is a list of what I've found.

    StoredProcedure:
    dbo.ReceiveAlertVariableTriggers

            Missing Drop #AlertsToUpdate


    StoredProcedure:
    dbo.spDrsSummarizeSendHistory

            Missing Drop #DrsSendHistorySummary


    StoredProcedure:
    dbo.spExpandCollectionUserMembership

            Missing Drop #temp


    StoredProcedure:
    dbo.spRBAC_SyncPermissions_Objects

            Missing Drop #AffectedInternalObjects
            Missing Drop #CollectionIDs


    StoredProcedure:
    dbo.sp_BgbCheckAndGenerateResTask

            Missing Drop #MachineToBeNotified


    StoredProcedure:
    dbo.sp_CollectedFile

            Missing Drop #ToDelete


    StoredProcedure:
    dbo.sp_FolderVerifyNoLoops

            Missing Drop #Parents


    StoredProcedure:
    dbo.sp_GetGroupsWithData

            Missing Drop #GroupsWithData


    StoredProcedure:
    dbo.sp_GetInvHistory

            Missing Drop #Instances
            Missing Drop #ReturnInstances


    StoredProcedure:
    dbo.sp_SetupApplicationDependence

            Missing Drop #tempRelations

    Monday, March 31, 2014 6:29 PM

All replies

  • Hi Martin,

    Do you remember which System Center components (e.g. Configuration Manager, Virtual Machine Manager, Data Protection Manager) were using this database? Knowing the components will help me direct this to the correct team.

    Also, do you know which version of System Center (e.g. 2008 R2, 2012, 2012 SP1, 2012 R2)?

    Kind Regards,

    Richard 


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Monday, April 14, 2014 4:26 PM