Article ID: 164576
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q164576
BUG #: 16591
SYMPTOMS
If you use "INSERT INTO SELECT <select statement>" to add rows to a table that has a non-unique clustered index and at least one non- clustered index, you may encounter the following error:
After this error occurs, the connection to SQL Server is broken.
WORKAROUND
To work around this problem, do any one of the following:
- Make the clustered index unique.
- Drop some or all of the non-clustered indexes for the duration of the insert.
- Drop the clustered index for the duration of the insert.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.
Keywords: kbfix kbusage KB164576