PDA

View Full Version : Visual Studio.Net Database management

bruce
03-20-2003, 07:11 AM
right click on the tables node, you should see an option New Table

[b]quote:Originally posted by scubabbl

I connect to my SQL database through the Visual Studio.net. I can view tables, but I can't seem to find out how to create new tables. Anyone know? Does the server explorer only allow viewing but not editing?
</blockquote id="quote"></font id="quote">
scubabbl
03-20-2003, 12:20 PM
I connect to my SQL database through the Visual Studio.net. I can view tables, but I can't seem to find out how to create new tables. Anyone know? Does the server explorer only allow viewing but not editing?
meadowstrav
04-07-2003, 07:11 AM
I have the same problem when using the server explorer in visual studio .net. And right clicking does not give the option to add a new table. Do we have to use SQL Server 2000 Enterprise manager or what?

[b]quote:Originally posted by scubabbl

I connect to my SQL database through the Visual Studio.net. I can view tables, but I can't seem to find out how to create new tables. Anyone know? Does the server explorer only allow viewing but not editing?
</blockquote id="quote"></font id="quote">
bruce
04-08-2003, 11:05 AM
Did you get any error message?



[b]quote:Originally posted by meadowstrav

I have the same problem when using the server explorer in visual studio .net. And right clicking does not give the option to add a new table. Do we have to use SQL Server 2000 Enterprise manager or what?

[b]quote:Originally posted by scubabbl

I connect to my SQL database through the Visual Studio.net. I can view tables, but I can't seem to find out how to create new tables. Anyone know? Does the server explorer only allow viewing but not editing?
</blockquote id="quote"></font id="quote">
</blockquote id="quote"></font id="quote">
CreativeLightning
04-10-2003, 10:54 AM
Mine is the same. I don't have the option to create a new table. I am using the Academic version of Visual Studio. I also have a connection to my local SQL server and I don't get the option with it either. It's MSDE. I am going to upgrade to the full version and see if I can get it locally.

scubabbl are you using Academic version?

gninthgiLevitaerC
bruce
04-11-2003, 11:27 AM
Try get your hand on MS SQL enterprise manager.

you can get it at http://www.microsoft.com/sql/evaluation/trial/

Download the trial version and install just the client tools


[b]quote:Originally posted by CreativeLightning

Mine is the same. I don't have the option to create a new table. I am using the Academic version of Visual Studio. I also have a connection to my local SQL server and I don't get the option with it either. It's MSDE. I am going to upgrade to the full version and see if I can get it locally.

scubabbl are you using Academic version?

gninthgiLevitaerC
</blockquote id="quote"></font id="quote">