Article ID: 259141 - View products that this article applies to.
This article was previously published under Q259141
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 57806 (SQLBUG_70)
A complex data modification query (an insert, update or delete) on a table that has multiple non-clustered indexes, which are based on some of the same columns, might cause the following error message to occur on the client during the compilation of the query:
If this error message occurs, the query does not run.
Server: Msg 8624, Level 16, State 1
Internal SQL Server error.
To work around this behavior, you can try the following:
Microsoft has confirmed this to be a problem in SQL Server 7.0 Service Pack 2. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0 Service Pack 2. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:
http://www.microsoft.com/sql/prodinfo/previousversions/downloads/servicepacks.mspxFor more information, contact your primary support provider.
Contact us for more help
Connect with Answer Desk for expert help.