Microsoft KB Archive/175659: Difference between revisions
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 49: | Line 49: | ||
== SYMPTOMS == | == SYMPTOMS == | ||
If you create an | If you create an "oversized" table (that is, a table with a width greater than 1,962 bytes), you will receive the following message:<br /> | ||
<div class="errormessage"> | <div class="errormessage"> | ||
Line 58: | Line 58: | ||
</div> | </div> | ||
<br /> | <br /> | ||
If this table does not have an index and you execute a query with an ORDER BY clause (such as | 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:<br /> | ||
<div class="errormessage"> | <div class="errormessage"> | ||
Line 104: | Line 104: | ||
c10 varchar(255) not null) | c10 varchar(255) not null) | ||
go | go | ||
insert t1 values( | insert t1 values("A","Z","Z","Z","Z","Z","Z","Z","Z","Z") | ||
insert t1 values( | insert t1 values("B","Z","Z","Z","Z","Z","Z","Z","Z","Z") | ||
insert t1 values( | insert t1 values("C","Z","Z","Z","Z","Z","Z","Z","Z","Z") | ||
insert t1 values( | insert t1 values("D","Z","Z","Z","Z","Z","Z","Z","Z","Z") | ||
insert t1 values( | insert t1 values("E","Z","Z","Z","Z","Z","Z","Z","Z","Z") | ||
insert t1 values( | insert t1 values("F","Z","Z","Z","Z","Z","Z","Z","Z","Z") | ||
insert t1 values( | insert t1 values("G","Z","Z","Z","Z","Z","Z","Z","Z","Z") | ||
insert t1 values( | insert t1 values("H","Z","Z","Z","Z","Z","Z","Z","Z","Z") | ||
insert t1 values( | insert t1 values("I","Z","Z","Z","Z","Z","Z","Z","Z","Z") | ||
insert t1 values( | insert t1 values("J","Z","Z","Z","Z","Z","Z","Z","Z","Z") | ||
go | go | ||
</pre> | </pre> |
Latest revision as of 11:07, 21 July 2020
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