BUG: Cannot Add Tables or See Database Diagrams (199881)


The information in this article applies to:

  • Microsoft Visual InterDev 6.0
  • Microsoft Visual Database Tools
  • Microsoft SQL Server 6.5
  • Microsoft SQL Server 7.0
This article was previously published under Q199881

SYMPTOMS

When attempting to use the Visual Database Tools in a Visual InterDev project, you cannot add data, new tables or view database diagrams and no errors or warnings appear.

CAUSE

The database's transaction log is full.

RESOLUTION

Purging the existing transaction log or allocating more space for the transaction log corrects this problem.

STATUS

Microsoft has confirmed this to be a bug in Visual InterDev 6.0.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Create a new Database project with Visual InterDev 6.0.
  2. Add a Data Connection to a SQL server and connect to a database whose log is full.
RESULT: You do not receive any errors connecting to the database. You also do not get a warning about why you cannot add a table or see the database diagrams in Data View. Note that with the professional version of Visual InterDev 6.0, you cannot add tables or other database objects by default. This is only possible with Visual InterDev 6.0 Enterprise Edition.
Modification Type:MinorLast Reviewed:8/19/2005
Keywords:kbBug kbDatabase kbInetDev kbpending KB199881
©2004 Microsoft Corporation. All rights reserved.