Microsoft KB Archive/260049

= FIX: Database Problems with Nulls and Data Type Precision =

Article ID: 260049

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 Q260049



SYMPTOMS
When you use the User Interface, in Visual Studio products, to create a database table, you are not able to create a bit column that allows nulls and you are not able to select the check box.

-or-

Start the database server with the -P switch, and then open the Enterprise Manager. Locate tempdb and add a table. Next, add a column as a decimal data type, and then try to set the precision to 38. An error message occurs. NOTE: With the -P parameter, a precision of up to 38 is allowed.

This article assumes a general working knowledge of database servers and their customization. If you need additional assistance with the steps in this article, please search the MSDN Library and Microsoft Knowledge Base for detailed instructions on configuration and customization of the Database and Connections.



RESOLUTION
To resolve either 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

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

260092 FIX: BUG: Create a table using Query Analyzer from Visual InterDev - SEM inserts decimal(9,0) values incorrectly

