MS SQL database Admin/IDE

I'm using MS SQL for a project, but have always used MySql in the past. MySql has a really nice interface which lets you build queries, offers help, backup etc.

What free programs are the开发者_JS百科re for MS Sql that can do this. I'm currently a student so I have free access to MS Sql but the only interface I have for it right now is Visual Studio 2008.

Any suggestions?

The SQL Server Management Studio is available in an "Express" edition as well. It's a separate download from SQL Server Express, though.

SQL Server Management Studio should come with SQL Server and is quite a nice and easy to use administrator tool.

• create DBs, tables etc.
• control permissions
• run queries
• and much much more