[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 :)

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

ok
but can this program provide me with more functionality & tools to manage my database than the visual studio IDE ?

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.

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:

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.

thx a lot :)

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 ....

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.

i meant that can i delete and add tables to the DB in VS IDE after i finished managing the DB in SSMSE ??

thx

Yes, you can do that.

ok thx a lot :)

now it is resolved :) :)

No problem. =)