[RESOLVED] sql server management studio express (general question)

[snakeman]

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

[brucevde]

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

[snakeman]

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

[dee-u]

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.

[snakeman]

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

[dee-u]

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.

[snakeman]

thx a lot

[snakeman]

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

[dee-u]

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.

[snakeman]

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

thx

[dee-u]

Yes, you can do that.

[snakeman]

ok thx a lot

now it is resolved

[dee-u]

No problem. =)