Microsoft KB Archive/256615

= SMS: Setup Time-Out Attempting to Create Indexes on Tables with Many Rows =

Article ID: 256615

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

-



This article was previously published under Q256615



SYMPTOMS
When you attempt to upgrade a Systems Management Server (SMS) 2.0 site that has tables that contain many rows (for example the StatusMessages or Software Inventory tables), Setup may time out and stop with a general error message. When this occurs, the SMSSetup log contains the following text:

<03-13-2000 17:40:49>FAILED Sql Script: Creating indexes on StatusMessages

<03-13-2000 17:40:49>SQL error



CAUSE
This behavior occurs because SQL runs the operation in Synchronous mode.



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:

236325 How to Obtain the Latest Systems Management Server 2.0 Service Pack



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Systems Management Server version 2.0 Service Pack 2.

Additional query words: prodsms

Keywords: kbbug kbfix kbsetup kbsms200sp2fix kbupgrade KB256615

-

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

© Microsoft Corporation. All rights reserved.