Article ID: 175659
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q175659
BUG #: 16074 (WINDOWS: 6.5)
SYMPTOMS
If you create an "oversized" table (that is, a table with a width greater than 1,962 bytes), you will receive the following message:
If this table does not have an index and you execute a query with an ORDER BY clause (such as "SELECT * from t1 ORDER BY c1"), you will receive the following message:
WORKAROUND
To avoid this problem, use a statement similar to the following to create an index on the table:
create index ti on t1(c1)
STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.
MORE INFORMATION
The following statements will reproduce the problem:
create table t1 (c1 varchar(255) not null, c2 varchar(255) not null, c3 varchar(255) not null, c4 varchar(255) not null, c5 varchar(255) not null, c6 varchar(255) not null, c7 varchar(255) not null, c8 varchar(255) not null, c9 varchar(255) not null, c10 varchar(255) not null) go insert t1 values("A","Z","Z","Z","Z","Z","Z","Z","Z","Z") insert t1 values("B","Z","Z","Z","Z","Z","Z","Z","Z","Z") insert t1 values("C","Z","Z","Z","Z","Z","Z","Z","Z","Z") insert t1 values("D","Z","Z","Z","Z","Z","Z","Z","Z","Z") insert t1 values("E","Z","Z","Z","Z","Z","Z","Z","Z","Z") insert t1 values("F","Z","Z","Z","Z","Z","Z","Z","Z","Z") insert t1 values("G","Z","Z","Z","Z","Z","Z","Z","Z","Z") insert t1 values("H","Z","Z","Z","Z","Z","Z","Z","Z","Z") insert t1 values("I","Z","Z","Z","Z","Z","Z","Z","Z","Z") insert t1 values("J","Z","Z","Z","Z","Z","Z","Z","Z","Z") go
Additional query words: sp sp2
Keywords: kbbug kbfix kbusage kbsqlserv650bug KB175659