Article ID: 260092
Article Last Modified on 8/7/2007
APPLIES TO
- Microsoft Visual Studio 6.0 Enterprise Edition
- Microsoft Visual Studio 6.0 Service Pack 1
- Microsoft Visual InterDev 6.0 Standard Edition
This article was previously published under Q260092
SYMPTOMS
When you type "123456789" in the SQL Enterprise Manager (SEM) and then choose to Return all rows from a table in Query Analyzer, the numbers that you entered are automatically changed to "123456800."
CAUSE
This problem is a result of the DaVinci bug in Visual Studio 6.0.
RESOLUTION
To resolve this problem, install the latest service pack for Visual Studio 6.0.
STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article. This bug was corrected in the latest service pack for Visual Studio 6.0.
For additional information about Visual Studio service packs, click the following article numbers to view the articles in the Microsoft Knowledge Base:
194022 INFO: Visual Studio 6.0 Service Packs, What, Where, Why
194295 HOWTO: Tell That a Visual Studio Service Pack Is Installed
To download the latest Visual Studio service pack, visit the following Microsoft Web site:
MORE INFORMATION
Steps to Reproduce Behavior
NOTE: To reproduce the behavior, you must understand how to create database connections and database design. If you need additional information, please see the MSDN Library documentation.
Perform the following steps on a computer running both Visual InterDev and Visual Studio Service 6.0 Pack 3 or earlier:
- In Query Analyzer, right-click the Tables folder, select Create new table, and then type "create table test(col1 decimal(9,0)."
- Open SEM (SQL Enterprise Manager), and then drill down to the table that you created in Query Analyzer.
- Right-click the table that you created, and then click Return all rows.
- Type "123456789," and then press ENTER. These digits change to "123456800."
REFERENCES
Additional query words: sp4 BetaPublic, VSSP4, vssetup, sp4releasefix
Keywords: kbbug kbfix kbvs600sp4fix kbvs600sp5fix KB260092