FIX: Unable to Create or Modify Tables or Views from Data View Window on SQL Server 2000

View products that this article applies to.

This article was previously published under Q274167

SYMPTOMS

When you right-click on the Tables or Views folders (or items within those folders) under a Data Link connected to a SQL 2000 Server, the New Table, New View, Design Table, Design View, and Filter By Owner menu items do not appear. These choices exist with SQL Server 7.0.

Back to the top

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 next 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 (http://support.microsoft.com/kb/194022/EN-US/ ) INFO: Visual Studio 6.0 Service Packs, What, Where, Why

194295 (http://support.microsoft.com/kb/194295/EN-US/ ) 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 (http://msdn2.microsoft.com/en-us/vstudio/Aa718353.aspx)

Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

Open a DataProject in Visual Basic 6.0.
Create a connection to SQL Server 2000 in the DataEnvironment.
Open the DataView window and expand the connection.
Right-click the Table folder.

NOTE: If Visual Studio 6.00 Service Pack 5 has been applied, you see New in the context menu.

The New option displays the following error message:

The Visual Database Tools within Visual Studio 6 and Access 2000 do not support some new features of SQL Server 2000. Because you are manipulating an object in a SQL Server 2000 database, some operations will be unavailable to you. In rare cases, you might not be able to save the database object you modified. In other cases, you will be able to save the object, but its previously existing settings for features new to SQL Server 2000 will be lost. In most of these cases, you will be warned if the Save operation will eliminate existing settings or property values.

For a complete description of the interaction between SQL Server 2000 and Visual Database Tools within Visual Studio 6 or Access 2000, see Microsoft Knowledge Base article Q266277, "Using Visual Studio 6 and Access 2000 Visual Database Tools with SQL Server 2000." Knowledge Base articles are available in the MSDN Library Visual Studio documentation or at http://support.microsoft.com/support/.

To suppress this message next time you design a SQL Server 2000 object from Visual Studio 6 or Access 2000, check the following box.

Back to the top

REFERENCES

"Considerations for Other Microsoft Products" under "Installing SQL Server" in SQL Server 2000 Books Online.

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

266277 (http://support.microsoft.com/kb/266277/EN-US/ ) PRB: Using Visual Studio 6 and Access 2000 Visual Database Tools with SQL Server 2000

Back to the top