The information in this article applies to:
SUMMARY
When creating an index, you might receive the following message (error
number 1520):
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.
Additional query words: Transact-SQL create clustered index Windows NT
Keywords : kbother SSrvServer SSrvWinNT |
Last Reviewed: March 17, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |