Hi All, ive just done a parent to child to swap over to new hardware for my Primary Site. All is working ok apart from a few sql error messages in the Status message viewer. Anyone any ideas on how to resolve these issues?Microsoft SQL Server reported SQL message 207, severity 16: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Decommissioned0'. Please refer to your SMS documentation, SQL documentation, or the Microsoft Knowledge Base for further troubleshooting information.Microsoft SQL Server reported SQL message 156, severity 15: [42000][156][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AS'. Please refer to your SMS documentation, SQL documentation, or the Microsoft Knowledge Base for further troubleshooting information.

Which ConfigMgr component generates these errors? Are they happening on a regular basis or did they appear only once?

SMS_COLLECTION_EVALUATOR component for Microsoft SQL Server reported SQL message 156, severity 15: [42000][156][Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AS'.the other one i cant check at the moment as i cleared the log but im pretty shore it was the same component.

SMS_COLLECTION_EVALUATOR component for Microsoft SQL Server reported SQL message 207, severity 16: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Decommissioned0'.these messages are recurring.

Also got this one.SMS Collection Evaluator failed to update the query rule "DO NOT DELETE" of collection "COM Servers not registered" (LA20002F). Possible cause: Inventory or Resource classes referenced in the query do not exist at this site, resulting in a SQL error.Solution: Enable the collection of the missing Inventory or Resource information at this site.nPossible cause: SQL Server problem.Solution: 1. Review the immediately preceding status messages from this component about SQL Server errors.2. Verify that this computer can reach the SQL Server computer.3. Verify that SQL Server services are running.4. Verify that SMS can access the SMS site database.5. Verify that the SMS site database, transaction log, and tempdb are not full.6. Verify that there are at least 50 SQL Server user connections, plus 5 for each SMS Administrator console. If the problem persists, check the SQL Server error logs.I cant find the DO NOT DELETE, i think it was an old collection but im sure i removed it ages ago.

See colleval.log to get the CollectionID of the collections that are failing to update their membership. Inspect the query rules of the affected ones and find out why they are failing (use wbemtest.exe or CIM Studio to check if the classes are existing in WMI and if the columns have still the same names etc).

in the log at the same time this message was logged Microsoft SQL Server reported SQL message 207, severity 16: [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Decommissioned0'.i get*** insert into #CollTemp (MachineID,ArchitectureKey,Name,SMSID,Domain ) select all SMS_R_UNKNOWNSYSTEM.ItemKey,SMS_R_UNKNOWNSYSTEM.DiscArchKey,SMS_R_UNKNOWNSYSTEM.Name0,SMS_R_UNKNOWNSYSTEM.Name0,SMS_R_UNKNOWNSYSTEM.Name0 from UnknownSystem_DISC AS SMS_R_UnknownSystem where SMS_R_UnknownSystem.Decommissioned0 = "0"*** [42S22][207][Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Decommissioned0'.CCollectionSource_SQL::RefreshResults - could not execute SQL cmd insert into #CollTemp (MachineID,ArchitectureKey,Name,SMSID,Domain ) select all SMS_R_UNKNOWNSYSTEM.ItemKey,SMS_R_UNKNOWNSYSTEM.DiscArchKey,SMS_R_UNKNOWNSYSTEM.Name0,SMS_R_UNKNOWNSYSTEM.Name0,SMS_R_UNKNOWNSYSTEM.Name0 from UnknownSystem_DISC AS SMS_R_UnknownSystem where SMS_R_UnknownSystem.Decommissioned0 = "0"STATMSG: ID=2542 SEV=W LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR" SYS=LAN-SCM-02 SITE=LA2 PID=2192 TID=3880 GMTDATE=Tue Jan 12 12:37:11.755 2010 ISTR0="Collection Query" ISTR1="All Unknown Computers" ISTR2="SMS000UC" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0Results refreshed for collection SMS000UC, 0 entries changed.COLLEVALTHREAD- Could not evaluate one of the rules for collection SMS000UC.COLLEVALTHREAD- Succeeded in refreshing collection SMS000UC.Checking collection: 0x2B, EvaluationCRCChanged=TRUE, ScheduleCRCChanged=FALSE, AwaitingRefresh=TRUECOLLEVALTHREAD- Due date for collection LAN000C2 is 01/12/10 14:43:00COLLEVALTHREAD- Preparing to refresh collection LAN000C2Refreshing results for collection LAN000C2Looks to me like its upset with the unknown computer collection which is a default collection.select SMS_R_UNKNOWNSYSTEM.ResourceID,SMS_R_UNKNOWNSYSTEM.ResourceType,SMS_R_UNKNOWNSYSTEM.Name,SMS_R_UNKNOWNSYSTEM.Name,SMS_R_UNKNOWNSYSTEM.Name from SMS_R_UnknownSystem where Decommissioned = "0"how do i solve this one?

The unknown computers collection is only available if R2 is installed. Is it really installed?

that will be the problem then...This is a new primary. Hi done a child parent to sync with my old primary to do a hardware swap. the old primary had R2 this box i havent installed it yet..Thanks Torsten