SQL Server or Visual Studio for database? Want to put VB front end onto it

[lithium1976]

I have installed both SQL Server Express and Visual Studio 2008 (Trial).

Which do I use to actually design database tables and queries? It seems I can use both? A few people have already stated the I use SQL Server, but am I right or wrong in thinking I can do it in either?

I ask becuase I want to put a VB front end onto it.

[Hack]

Yes, you can use both. In fact, I would suggest housing your queries in stored procedures, and call them from your VB.NET front end.

[lithium1976]

Thanks! Thats cleared that up! So I take it the two programs have basically the same functions and methods of writing at least a basic database?

[techgnome]

Yes, And no..... currently (unless it changed in 2008 and I haven't found it yet).... when you create a stored proc in VS, there isn't a way to run it to get it into the database (or update it).... that still requires using Management Studio....

-tg