[RESOLVED] sql server management studio express (general question)
hey guys
when i was watching video lessons about sql server 2005 express edition,
i saw a program called sql server management studio express
what is exactly?
can i use it for my program ( i am now creating program in VB.NET 2008 with a sql server 2005 express edition database connected to it via ADO.NET)?
thx :)
Re: sql server management studio express (general question)
SQL Server Management Studio Express is a graphical tool to manage your SQL Server 2005 Express databases. It is free to download.
More info can be found here
http://msdn.microsoft.com/en-us/libr...7(SQL.90).aspx
Re: sql server management studio express (general question)
ok
but can this program provide me with more functionality & tools to manage my database than the visual studio IDE ?
Re: sql server management studio express (general question)
I believe it is more powerful. You can open various databases with it. I had only a brief stint with designing in the VS IDE and I think you have to attach the database so you can work with it, in the Management Studio it is not the case.
Re: sql server management studio express (general question)
Quote:
Originally Posted by dee-u
I had only a brief stint with designing in the VS IDE and I think you have to attach the database so you can work with it, in the Management Studio it is not the case.
what do you mean exactly??:confused:
Re: sql server management studio express (general question)
I meant I just tried it for a while then shifted to solely using the Management Studio, perhaps I may have missed something but I deem it that using the Management Studio will provide you with more options.
Re: sql server management studio express (general question)
Re: [RESOLVED] sql server management studio express (general question)
Sorry i remembered a question
if i used SSMSE to add tables & etc.... & T-SQL to my database, then will i be able to connect my VB App to the DB via ado.net and see all the things i added to my DB in SSMSE and change it in VS IDE?????
sorry for marked it as resolved ....
Re: [RESOLVED] sql server management studio express (general question)
Yes you can connect and still view the changes you have made although I am not sure what you meant by change it in VS IDE.
Re: [RESOLVED] sql server management studio express (general question)
i meant that can i delete and add tables to the DB in VS IDE after i finished managing the DB in SSMSE ??
thx
Re: [RESOLVED] sql server management studio express (general question)
Re: [RESOLVED] sql server management studio express (general question)
ok thx a lot :)
now it is resolved :) :)
Re: [RESOLVED] sql server management studio express (general question)