SQL Server 2008 Management Studio Express and full version


  • We have SQL server 2008 installed in a virtual server and I just want to download tools for querying my pc. I downloaded the SQL Server 2008 Managemnt Express and installed the tools. My DBA is saying remove the express install and install the tools from the full version. Is he correct or could I have used the SSME install to query the full version?

    Tuesday, October 05, 2010 1:02 PM


  • Yes, you can use management studio express to connect and query other SQL Server editions (Standard, Enterprise etc.)

    However, to utilize feature set available in full management studio if you have of media or setup for other editions (non-express) of  SQL Server then I suggest you install and use full management studio.

    Tuesday, October 05, 2010 1:17 PM