Microsoft KB Archive/832955

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

Article ID: 832955

Article Last Modified on 1/22/2007

-

APPLIES TO


 * Microsoft Visual Studio .NET 2003 Enterprise Architect
 * Microsoft Visual Studio .NET 2003 Enterprise Developer
 * 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
 * Microsoft Visual Studio .NET 2002 Enterprise Developer
 * Microsoft Visual Studio .NET 2002 Professional Edition
 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2000 64-bit Edition

-



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 &quot;Applies to&quot; section of this article.



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.
 * 1) Start a new instance of the Visual Studio .NET 2003 development environment.
 * 2) Create a new Windows application in a Visual Basic .NET project.
 * 3) 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.
 * 4) 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.

