When I right-click on the Table node under Data Connections in Visual Studio 2003's Server Explorer I don't get the New Table node in the pop-up menu (XP SP2 and MSDE). This doesn't appear to be a database permissions issue as I can access the same database and create tables from the same security context using alternative tools (osql, SqlClient.SqlCommand, Enterprise Manager). Nor does it appear to be related to the version of Visual Studio as an installation of the same version of VS.NET on W2k/SQLServer works fine.
Is the "New Table" Server Explorer pop-up blocked by XP SP2 or something wierd
Can't create new Tables, Views or Stored Procs from Server Explorer
Hot Topic
- Same problem
- How to read and write to a file Asynchronously
- program not responding when debugging
- NullReference exeption dealing with array of listbox
- Connection String To Northwind
- Help about VBExpress
- change column width in a datagrid
- Highlight Items in ListView
- Very slow speed on displaying controls in a form
- troubles getting TryParse to work.
Visual Basic
- Problem populating table with a SQL Cursor from VB GUI
- How to make subroutine calls from one form to another non-blocking?
- Urgent!! Playing a memory stream to WMP
- Public Const issue
- finding directory size in vb.net
- How to make a ProgressBar work like a TrackBar
- Saving variable values
- Tricky one for you all. WMI and CPU Utilisation.
- What has replaced ---CopyArray--- function is Visual Basic Express Beta 2
- Create application to used by multi users at same time
Can't create new Tables, Views or Stored Procs from Server Explorer
Huxwell
Apparently, only MSDE databases can be changed from Visual Studio .Net Professional edition. The database that that I could make changes to such as creating new database, new database diagram, new table, etc. were from the MSDE instance.
The other instance of SQL Server, would not allow me to make these changes. Apparently VS .Net Enterprise edition is needed to do that.
Hope that helps other folks ... I noticed the original posting has been visited many times.
kasra007
In my case, I have 2 instances of SQL Server installed on the same computer. In Visual Studio .Net one of the instances is allowing me to create new tables, database diagrams, etc. The other one does not.
The first one lists Database Diagrams, Tables, Views, Stored Procedures, and Functions when I expand a Database. The second one only lists Tables, Views, and Stored Procedures.
Why is one instance allowing me to change the structure but the other one isn't
Help!