Monday, July 05, 2004 1:06 PM szurgot

Managing SQL Server Express Beta 1

When Sam Gentile is having trouble with a product, you now that things aren't right in the world.

Even though SQL Server express doesn't come with a UI for managing it, one ships right alongside it in the Express development kits. Just pull up Server Explorer, and attach to the file name (Server name is .\SQLExpress, use the attach option) Unlike Server Explorer for VS Pro, it's actually a full featured server manager, allowing you to do all the database manipulation on the tables, and what not. Pretty cool.

I've already ported a small app to SQL Express and VC# Express, and it's working great!

My only real gripe at this point is that you can't drag a table from the Server Explorer to a form like you can with VS 2003. Guess I'll report it as a bug.

Filed under:

Comments

# re: Managing SQL Server Express Beta 1

Monday, July 05, 2004 2:17 PM by Frans Bouma

The absense of a simple query analyzer tool is really bad. Also the necessity to add an .mbf file to your vs.net express project to work with a database is not great. The toolwindows furthermore in vs.net are hard to use: they are often VERY TINY and not resizable, so you have to scroll like a madman.

I don't like Oracle 10g's webinterface either, but it's way better than this. I hope the final product gets better.