Hi we are using SCCM 2007 with SP2, one of our DP has stopped working suddenly, we are getting the following error from the distmgr.log. i got a solution with a hot fix in this link http://support.microsoft.com/kb/810817 for SMS 2003, can you help me getting the solution for SCCM 2007 distmgr.log Updating package info for package PRI0011C SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) Only retrying local DP update for package PRI0011C, no need to replicate package definition to child sites or DP info to parent site. SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) SQL>>>set quoted_identifier off;set ansi_warnings off;set ansi_padding off;set ansi_nulls off;set concat_null_yields_null off;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) SQL>>>select Name,Version,Language,Manufacturer,Description,Source,SourceSite,StoredPkgPath,StoredPkgVersion,ShareName,PreferredAddress,StorePkgFlag,ShareType,Permission,RefreshSchedule,LastRefresh,UseForcedDisconnect,ForcedRetryDelay,DisconnectDelay,IgnoreSchedule,Priority,PkgFlags,MIFFilename,MIFPublisher,MIFName,MIFVersion,SourceVersion,SourceDate,SourceSize,SourceCompSize,ImageFlags,Hash,NewHash,HashVersion,Architecture,ImagePath,PackageType,AlternateContentProviders,SourceLocaleID FROM SMSPackages AS SMSPackages where PkgID = 'PRI0011C' and Action <> 3 SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) SQL>>>select AlgorithmPreference, HashAlgorithm, Hash, SignatureHash from SMSPackageHash where PkgID = "PRI0011C" SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) SQL>>>select UserGroup, Access from PkgAccess where PkgID = "PRI0011C" order by UserGroup SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) SQL>>>set quoted_identifier off;set ansi_warnings off;set ansi_padding off;set ansi_nulls off;set concat_null_yields_null off;set arithabort on;set numeric_roundabort off;set DATEFORMAT mdy; SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4) SQL>>>>> Done. SMS_DISTRIBUTION_MANAGER 8/12/2010 5:52:08 PM 10228 (0x27F4)Thanks Shankar K

Which error are you talking about. I cannot see any in the log you provided. BTW: there's SQL logging enabled which is not the best idea from a performance point of view.

How to disable this SQL logging.Thanks Shankar K

SQL tracing: http://support.microsoft.com/kb/828363/en-us