Suggestions for SQL Server GUI?

I just downloaded SQL Server 2005 Express edition. I was hoping it would come with a GUI to let me design my tables and such, but it doesn't. I'm working with ColdFusion/CF Builder here, so I don't really want one that integrates into Visual Studio. Also, it would be helpful if it has the 开发者_开发问答option to connect to a remote database too. Suggestions?

SQL Server Management Studio Express should have been installed with your download. If not, you can get it here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Consider using the latest version of SQL Server Express (2008), which can be found here: http://www.microsoft.com/express/Database/

The path for SSMS in the 2008 edition is

"C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

I would imagine that on 2005 the path will be the same but replace the 100 with 90. If it is not there then you can redownload it and add it to your instalation