Server Explorer doesn't offer database design features
I have installed
Visual Studio 2003Professional with
Visual Studio Tools for Office 2003 and SQL Server 2000 Developer Edition on the same system running XP SP 2. Using the Server Explorer I can see the databases registered to SQL Server and connect to them. I can see the various objects in the sample databases (Northwind and Pubs) such as tables, views, and stored procedures (but nothing else). I can see the data stored in the tables. However, I can't use any of the design features. When I right-click on table I only get four choices (only three of which I remember) "Retrieve", "Refresh", and "Properties". The "Table Design" choice isn't offered (its not greyed-out it doen't even appear as as choice).If I use SQL Server Enterprise Manager I can access the "Table Design" feature to view and alter the tables design.
I am new to both Visual Studio and SQL Server so any suggestions would be appricated.
