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
- Edited by martin stauber Monday, March 31, 2014 10:54 PM