BUG: Cannot Add Tables or See Database Diagrams

ID: Q199881

The information in this article applies to:

Microsoft Visual InterDev, version 6.0
Microsoft Visual Database Tools, version 1.0
Microsoft SQL Server versions 6.5, 7.0

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

Create a new Database project with Visual InterDev 6.0.

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.

Additional query words: kbDSupport

Keywords : kbDatabase kbInternet kbODBC kbVisID600 kbVisID600bug kbGrpASP kbSQLServ650 kbSQLServ700 kbInetDev
Version : WINDOWS:1.0,6.0; winnt:6.5,7.0
Platform : WINDOWS winnt
Issue type : kbbug