Hello, Running the script set nocount on create table #spaceused ( name nvarchar(120), rows char(11), reserved varchar(18), data varchar(18), index_size varchar(18), unused varchar(18) ) declare Tables cursor for select name from sysobjects where type='U' order by name asc OPEN Tables DECLARE @table varchar(128) FETCH NEXT FROM Tables INTO @table WHILE @@FETCH_STATUS = 0 BEGIN insert into #spaceused exec sp_spaceused @table FETCH NEXT FROM Tables INTO @table END CLOSE Tables DEALLOCATE Tables select * from #spaceused drop table #spaceused exec sp_spaceused tolist the tables I was getting the following errors: Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'ActiveSync_Service_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Add_Remove_Programs_64_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Add_Remove_Programs_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'AttributeMap_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'AUTOSTART_SOFTWARE_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'BROWSER_HELPER_OBJECT_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CAL_Device_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CAL_User_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CD_ROM_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_CategoryInstances_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_CategoryInstances_Flat_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_CICategories_All_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_CICategories_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_ConfigurationItemRelations_Flat_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_ConfigurationItems_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_CurrentComplianceStatus_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_LocalizedCategoryInstances_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_LocalizedProperties_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_UpdateCIs_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CI_UpdateSources_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'ClientOfferStatus_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'CollectionMembers_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Collections_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Computer_System_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Connected_Device_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Desktop_Monitor_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_CertificateInfo_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_Certificates_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_Computer_Syste_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_Display_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_FileSystem_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_Memory_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_Network_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_OS_Information_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_OwnerInformation_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_PhoneIdent_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_Power_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Device_UserInformation_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Disk_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'GroupMap_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'IDE_Controller_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'INSTALLED_EXECUTABLE_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'INSTALLED_SOFTWARE_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'INSTALLED_SOFTWARE_MS_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Keyboard_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Logical_Disk_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_CAL_ProductList_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_Category_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_Category_Local_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_CPU_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_HardwareRequirements_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_HardwareRequirements_Local_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_MSProd_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_SoftwareCode_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_SoftwareHash_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_SoftwareList_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'LU_SoftwareList_Local_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Modem_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Motherboard_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Mouse_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'NAP_CLIENT_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'NAP_System_Health_Age_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Netcard_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Network_Client_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Network_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Operating_System_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Parallel_Port_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Partition_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'PC_BIOS_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'PC_Memory_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'PkgPrograms_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'PNP_DEVICE_DRIVER_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Processor_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'ProgramOffers_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'RecentlyUsedApps_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'ScanPackage_Version_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'SCSI_Controller_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Services_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Sites_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'SMS_Advanced_Client_S_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'SMSPackages_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'SOFTWARE_SHORTCUT_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Software_Updates_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Software_Updates_Extended_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Sound_Devices_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'SSL_CONFIGURATIONS_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'SW_LICENSING_PRODUCT_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'SW_LICENSING_SERVICE_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'SYSTEM_CONSOLE_USAGE_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'SYSTEM_CONSOLE_USER_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'System_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'System_Devices_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'System_DISC_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'System_Enclosure_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'System_SMS_Instal_ARR_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Tape_Drive_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Update_ComplianceStatus_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Update_DetectionStatus_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Update_ScanStatus_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'USB_Controller_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'USB_DEVICE_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Video_Controller_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Virtual_Application_Packages_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Virtual_Applications_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Virtual_Machine_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'VULNERABILITY_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'VULNERABILITY_DETAIL_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'Windows_Update_Agent__DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62 The object 'WorkstationStatus_DATA_DD' does not exist in database 'SMS_SRV' or is invalid for this operation. What are the tables referenced in these errors? It is happening on several servers... Thanks,DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support

Those tables that end with _DD are not created by ConfigMgr by default.

interresting... the _DD looks loke a Delete comand sometimes ago.... Let me check as I have three production servers with them now... even on the test servers... System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support

See my reply here: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/64cb2579-f649-4519-b94e-f07e590e1730 I just ran your SQL script in my testlab and it showed the same errors (_DD etc). So I guess you can ignore them and use the query from the link in the article mentioned in the other thread. I don't know why those _DD are in sysobjects.

Thanks for the follow-up DomSystem Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 Support