Microsoft KB Archive/101348
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