Wednesday, March 21, 2012

Installed SQLServer Express.....now what?

Hi

I've succesfully installed Visual C# and I've made a couple of example projects. I now want to try and create a database and see if I can make a C# application that talks to it.

So I've installed SQL Server Express. I was hoping I could open it up and get started with creating tables etc. Instead, my Start menu shows:

Microsoft SQL Server 2005

>>>Configuration Tools

>>>>>>SQL Server Configuration Manager

>>>>>>SQL Server Error and Usage Reporting

>>>>>>SQL Server Surface Area Configuration

Where do I go now? Is there some configuring to do before I can start making tables and storing data? Or, have I misunderstood what SQL Server is about?

Thanks


Rich

For one thing, VS provides tools that allow you to create databases and then fill them with all kinds of database goodness. (i.e. Tables, Views, Stored Procedures, you name it.) They pretty much give you everything you need.

If you want to use the SQL Tools to do this, you'll need to download SQL Management Studio Express, which you can get from the SQL Express download page. Once you install SSMSE, you'll see another item on your Start menu.

Mike

No comments:

Post a Comment