Microsoft KB Archive/101348

From BetaArchive Wiki

INFO: Incorrect dpages Error When Creating an Index


The information in this article applies to:

  • Microsoft SQL Server version 4.2x


When creating an index, you might receive the following message (error number 1520):

Sort failed because dpages in the sysindexes row for table '%.*s' in database '%.*s' had an incorrect value. Please run DBCC CHECKTABLE on this table to find the correct value, then contact Technical Support.


The CREATE INDEX command allocates a work area based on the number of data pages (sysindexes.dpages) in the table. If this value is too low, the work area is too small and the sort fails. SQL Server versions 1.x did not automatically correct the dpages count when a DBCC CHECKTABLE or DBCC CHECKDB was run, so the message directed the user to contact Technical Support to help correct the dpages value.

The DBCC CHECKTABLE and CHECKDB commands in version 4.2 of SQL Server updates the dpages entry to the proper value when they are run. If running DBCC CHECKTABLE corrects the dpages count and reports no other errors, then there's no need to contact your support provider.

Additional query words: Transact-SQL create clustered index Windows NT

Keywords : kbother
Issue type : kbinfo
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2

Last Reviewed: February 6, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.