Microsoft KB Archive/260092

= FIX: If You Create a Table With Query Analyzer from Visual InterDev then the SQL Enterprise Manager Inserts the Incorrect Decimal (9, 0) Values =

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 &quot;123456789&quot; 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 &quot;123456800.&quot;



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:

http://msdn2.microsoft.com/en-us/vstudio/Aa718353.aspx



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:
 * 1) In Query Analyzer, right-click the Tables folder, select Create new table, and then type &quot;create table test(col1 decimal(9,0).&quot;
 * 2) Open SEM (SQL Enterprise Manager), and then drill down to the table that you created in Query Analyzer.
 * 3) Right-click the table that you created, and then click Return all rows.
 * 4) Type &quot;123456789,&quot; and then press ENTER. These digits change to &quot;123456800.&quot;

