Question by callumitus: Can you install MS SQL Management studio for Express onto MS SQL standard?
Just a short one.
Can you install MS SQL Management studio for Express onto a server hosting MS SQL standard? Will it log into SQL Standard?
Answer by klap0161
I would not recommend to install MS SQL Server Management Studio Express on the same box as MS SQL Server has been installed on. However, you can install MS SQL Server Management Studio Express on another box and manage all SQL Server 2005 editions (Express, Standard, Enterprise).
Please note that SQL Server Management Studio Express has limited functionality compared to the none-express edition.
Know better? Leave your own answer in the comments!