Microsoft KB Archive/264378

= SMS: Site System Summarizer May Deadlock =

Article ID: 264378

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Systems Management Server 2.0 Standard Edition
 * Microsoft Systems Management Server 2.0 Service Pack 1
 * Microsoft Systems Management Server 2.0 Service Pack 2

-



This article was previously published under Q264378



SYMPTOMS
On Systems Management Server (SMS) 2.0 sites that are running with Microsoft SQL Server 7.0, a SQL deadlock may occur, affecting Site System Status Summarizer and Component Status Summarizer.



CAUSE
The deadlock occurs because Site System Status Summarizer and Component Status Summarizer share a SQL table that holds the Site System status and Component status for the site.



RESOLUTION
To resolve this problem, obtain the latest service pack for Systems Management Server version 2.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

288239 SMS: How to Obtain the Latest Systems Management Server 2.0 Service Pack



STATUS
Microsoft has confirmed this to be a problem in Systems Management Server version 2.0 This problem was first corrected in Systems Management Server 2.0 Service Pack 3..



MORE INFORMATION
For additional information about the Component Status Summarizer hotfix, click the article number below to view the article in the Microsoft Knowledge Base:

249121 SMS: COMMIT TRANSACTION Request Has No Corresponding BEGIN TRANSACTION

Additional query words: prodsms

Keywords: kbqfe kbhotfixserver kbbug kbdatabase kbfix kbsms200presp3fix KB264378

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.