INFO: You Cannot Use Visual InterDev to Create or Modify SQL Server 2000 Tables, Views, or Database Diagrams (261153)

This article discusses a Beta release of a Microsoft product. The information in this article is provided as-is and is subject to change without notice.

No formal product support is available from Microsoft for this Beta product. For information about how to obtain support for a Beta release, see the documentation that is included with the Beta product files, or check the Web location from which you downloaded the release.

SUMMARY

When you work with a SQL Server 2000 database from within the Visual InterDev 6.0 database design tools, you cannot create or modify tables, views, or database diagrams.

If Visual Studio Service Pack 4 is installed, you will receive the following error message when you try to create or modify tables, views, or database diagrams:

This version of the database design tools is not compatible with SQL Server 2000, so you cannot save changes from this tool to the SQL Server 2000 database. To modify a SQL Server 2000 database, use the SQL Server 2000 Enterprise Manager.

If Visual Studio Service Pack 3 or earlier is installed, there will be no context menu items available from within the database design tool for you to use to create or modify tables, views, or database diagrams.

MORE INFORMATION

The Visual InterDev 6.0 database design tools are not compatible with SQL Server 2000. You must use the SQL Server 2000 Enterprise Manager to make modifications to the database.

REFERENCES

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 Visual Studio 6.0 Service Pack 5.

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/