FIX: Database Problems with Nulls and Data Type Precision (260049)


The information in this article applies to:

  • Microsoft Visual Studio, Enterprise Edition 6.0
  • Microsoft Visual Studio 6.0 SP1
  • Microsoft Visual InterDev 6.0
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://msdn.microsoft.com/vstudio/downloads/updates/

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

REFERENCES

Modification Type:MinorLast Reviewed:12/12/2005
Keywords:kbBug kbfix kbVS600fix KB260049
©2004 Microsoft Corporation. All rights reserved.