Microsoft KB Archive/101348

{|
 * width="100%"|

INFO: Incorrect dpages Error When Creating an Index

 * }

Q101348

-

The information in this article applies to:


 * Microsoft SQL Server version 4.2x

-

SUMMARY
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.

MORE INFORMATION
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