I have installed Visual Studio 2003 Professional 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.
Server Explorer doesn't offer database design features
Hot Topic
- What is the Rs web service for?
- Restore MDF problem
- Capturing the results from exec command
- Install SQL Server 2005 for Developer
- NameSpace of ReportingService class
- Performance on wan
- Using AMO to create a Named Set in Analysis Services Database 2005??
- Updating Table Structures
- nsInstance.Initialize errors out
- BIDS programming
SQL Server
- Fail to uninstall SQLServer 2005
- "The statement did not return a result set" error on SPs with exec
- Authentication Issues
- HELP! Problem in my code
- how to change the order of rows in datatable randomly?
- Encryption and recovery on standby machine
- WHERE includes all letters
- Attempted to divide by zero
- need help on a query
- Programmatically Render Report to PDF
Server Explorer doesn't offer database design features
begginer666