Last post Jun 26, 2006 12:06 AM by tbase2000
Jul 26, 2005 04:48 PM|ArthurZhang|LINK
I have SQL server 2000 developer edition and visual studio 2003.net developer edition installed on my windows 2000 machine. I set my computer's login ID as the server name and check to use windows NT integrated security when log on to the SQL server on my
computer. After setting up connection with SQL server, I can access SQL server database (view all tables, retrieving data) through visual Studio.NET’s server explorer, however I can't create new table, new view using server explorer's visual design interface.
The only buttons show on the context menu when i right click a table are "retrieve table","refresh","copy","properties". I wonder if this problem is related to SQL server's access permission, if so, how could i solve it? Any suggestion is appreciated.
Jul 27, 2005 01:19 PM|sivilian|LINK
The Developers Edition of Visual Studio does not contain all the functionality that Enterprise Architect has within Server Explorer. Thus some options will be unavailable with this edition.
hope this helps,
Jun 26, 2006 12:06 AM|tbase2000|LINK
MSDE Database has all the options he's talking about...so why not SQL... I have the exact same problem.
The server explorer is absolutely useless without the basic options of create new database, create table...etc
Is that really the answer?