General information
Title:
Create connection to Sql database
I have a Sql Server database that I have been given owner access to. I want to use Visual Studio .Net 2003 Server Explorer to create tables and manage the tables in Sql Server.
I currently do this with my MSDE database on my PC and can create and manage the tables in MSDE.
My problem is that when I Add a Connection using the Server Explorer in .Net, and create a connection to my Sql Server database, I am not able to create a table using the Server Explorer interface. I can connect just fine and view any exisiting tables and data in the database but, in the Server Explorer, if I right click on the Tables tree node, the 'New Table' menu option does not appear on the shortcut menu. The 'New Table' menu option does appear on the database I have created in MSDE, but not on the SQL Server tables tree node.
How can I create a table in my Sql Server database using .Net's Server Explorer?
Thanks,
Jerry
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only