Problem with sqlserver 2005

[k3pos]

Problem with sqlserver 2005

i have downloaded visual basic 2005 express edition from here
link

when i install it asks me to install sqlserver 2005 express edition and i said yes and it installed

but now i dont find that sql thing.. how do i opreate it ? is it spose to really install me the sqlserver or that i need to redownload it by its self ?

[si_the_geek]

By default SQL Server Express does not have an interface - it can only be used via code.

To get an interface for it, you can download Management Studio Express. See the SQL Server 2005 thread at the top of the Database Development forum for a link to it.

[jmcilhinney]

There's actually no need for Management Studio Express if you use SQL Server Express in the "default" manner in VB Express because it's well integrated into the IDE. You can add an SQL Server database to your project the same way you add any other item: right-click the project, select Add Item and then select SQL Server Database as the item type. This adds an MDF file to your project and an entry for that file in the Database Explorer window. You can now expand that Database Explorer node and add tables, stored procedures, etc. to the database right there in VB Express. When you deploy your app you include SQL Server Express and you MDF file in your deployment and it all works seemlessly.

Don't get me wrong, Management Studio Express is a very good and useful tool and you won't lose anything by installing it. It's just not actually required in most simple cases, which is why it's not included in the default installation.

[k3pos]

i downloaded it and i see that i can get into it and see the DB's but i dont see anything that makes a new db or new tables...

its to hard for me i think i am stuck with access =]

[jmcilhinney]

Try using your right mouse button a bit.