BUG: The dtproperties system table is displayed as a user table in Visual Studio .NET Server Explorer (832955)


The information in this article applies to:

  • Microsoft Visual Studio .NET (2003), Enterprise Architect Edition
  • Microsoft Visual Studio .NET (2003), Enterprise Developer Edition
  • Microsoft Visual Studio .NET (2003), Professional Edition
  • Microsoft Visual Studio .NET (2003), Academic Edition
  • Microsoft Visual Studio .NET (2002), Academic Edition
  • Microsoft Visual Studio .NET (2002), Enterprise Architect Edition
  • Microsoft Visual Studio .NET (2002), Enterprise Developer Edition
  • Microsoft Visual Studio .NET (2002), Professional Edition
  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 2000 Enterprise Edition 64-bit

SYMPTOMS

If you create a Microsoft Windows application, and you connect to a Microsoft SQL Server 2000 database by using Microsoft Visual Studio .NET Server Explorer in a Visual Studio .NET 2003 environment, the dtproperties system table may be displayed as a user table in Visual Studio .NET Server Explorer.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section of this article.

MORE INFORMATION

Steps to Reproduce the Problem

  1. Start SQL Server Enterprise Manager.
  2. In SQL Server Enterprise Manager, log on to an instance of SQL Server 2000 as a system administrator.
  3. Make sure that execute permissions are PUBLIC for the sp_MS_marksystemobject system stored procedure.
  4. Create a new SQL Server account named test, and then make the SQL Server account a member of the Database Creator fixed server role.
  5. In SQL Server Enterprise Manager, log on to the instance of SQL Server 2000 by using the test SQL Server login account that you created in step 4.
  6. Create a new database named TestDB in the instance of SQL Server.
  7. Create a new table named TestTab in the TestDB database.

    Note The dtproperties system table is created in the TestDB database.
  8. Start a new instance of the Visual Studio .NET 2003 development environment.
  9. Create a new Windows application in a Visual Basic .NET project.
  10. Add a database connection by using Visual Studio .NET to the SQL Server database that you created in step 6. Make sure that the database connection uses the test SQL Server account.
  11. Expand the database connection node in Visual Studio .NET Server Explorer, and then expand the Tables node.

    Note The dtproperties system table is displayed under the Tables node with the other user tables in the database.

REFERENCES

For more information about granting permissions, see the "Granting Permissions" topic in SQL Server 2000 Books Online.

For more information about creating connections to SQL Server from a Windows application, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/en-us/vbcon/html/ vbtskcreatingconnectiontosqlserver.asp

Modification Type:MinorLast Reviewed:9/14/2005
Keywords:kbvs2002sp1sweep kbtable kbUser kbSysAdmin kbdisplay kbBug KB832955 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.