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?
+3
A:
SQL Server Management Studio Express should have been installed with your download. If not, you can get it here:
Consider using the latest version of SQL Server Express (2008), which can be found here: http://www.microsoft.com/express/Database/
Robert Harvey
2010-02-04 03:41:07
Thanks. I don't see it in my start menu and I don't know what to look for in the actual install folder. Went with 2005 because that's what my server is running :)
Mark
2010-02-04 03:49:16
A:
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
Kevin Ross
2010-02-04 08:17:03