Removing Old (orphaned) Site Systems from the SMS and ConfigMgr 2007 Database

This method was developed for SMS 2.0 and 2003, but works equally well for Configuration Manager 2007. Open SQL Enterprise Manager Open the SMS Database and then go to Tables Select the Table: “Summarizer_SiteSystem” Right click on the table and select Open Table-Return All Rows Place a -1 in the Replicate Column for all instances of the specific Servers that no longer...

Read More»