Eu ja detectei o registro que o SMS está querendo duplicar.Nós usamos dois servidores SQL, um tem o SQL SERVER 2000 SP4 e o outro o SQL SERVER 2000 RTM.Esse erro está dando no servidor que usa o SQL SERVER 2000 SP4.Eu tava vendo o log desse serviço no SMS e pelo que vi, o sms está tentando executar alguns comandos no sql e não está conseguindo... vejam as mensagens:
CPolicyProvider::UpdateDeviceMPSettings: could not execute SQL cmd IF EXISTS (select * from DeviceMPSettings where ID = 'ClientAuthEnabled') update DeviceMPSettings set StringValue1 = 'false' where ID = 'ClientAuthEnabled' else insert DeviceMPSettings (ID, StringValue1, StringValue2, DWordValue) values ('ClientAuthEnabled', 'false', '', 0) SMS_POLICY_PROVIDER 10/29/2007 2:59:37 PM 11972 (0x2EC4)
CPolicyProvider::UpdatePolicyMap: could not execute SQL cmd select COUNT(*) from ResOfferCollMapChg_Notif
*** insert Policy (PolicyID, Version, DeviceVersion) values ("DEP-T0120000-T0100001-37A8072D", "16.00", "16.00");~select OfferID, PolicyID, PolicyAssignmentID, PADBID from SoftwarePolicy where PkgID = "T0100002" and ProgramName = "Microsoft Updates Tool (expedited)" and ParentPolicyID = "none";~select t2.PolicyID from (MeterRules as t1 RIGHT JOIN MeteringPolicy as t2 on t1.SecurityKey = t2.MeterRuleID and (t1.SiteCode = "T01" or t1.ApplyToChildSites = 1)) where t1.RuleID is null and t2.MeterRuleID <> 'NONE';~select PkgID, MSIProductID, MSIFilePath from PkgPrograms where MSIProductID <> "" AND Action <> 3 order by PkgID, MSIProductID ASC;~select t2.PolicyID from (InventoryAction as t1 RIGHT JOIN SettingsPolicy as t2 on t1.ActionID = t2.SourceID) where t1.ActionID is null and t2.SourceType = 'InventoryAction';~select ActionID, ReportType, ReportDestination, Description, DefaultTimeout, ReportTimeout, LastUpdateTime from InventoryAction
Alguem tem alguma sugestão?
