What is the diffrence between SQL Express and SQL Managment Studio ?

[nileshbahirshet]

Hi... I want to know the diffrence between SQL Express and SQL mangment studio. On my PC which is standalone ,SQL server 2008 Insrtalled but I unable to see any database or anything.I can see only Configration manager. So On my pc SQL express installed or Only Managment studio installed ? Which application I have to install so I can create the database ?

[Mycroft Holmes]

One is a database edition The other is a management toll for the database (create and test database objects, tables, views, procedures etc)

[Niladri_Biswas]

Check this one out http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx[^] :)

Niladri Biswas

[Lost User]

SQL Express[^] is the "express" version of SQL Server, meaning that it's a trimmed down version of SQL Server and available as a free download. SQL Management Studio[^] is an IDE to manage databases. In other words, the first thing is a database-server, the second thing is a GUI to manage that server.

I are Troll :suss: