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