Can SQL Server Express be used to effectively administrate a SQL Server Standard/Enterprise installation?
We have a number of MS SQL Server 2005 installations (both Standard and Enterprise editions) on our webservers. From time to time I need to administrate them from home. Right now I'm using Remote Desktop to connect to my work machine, but I'd prefer to install SQL Server Management Studio on my home machine so that I can work more efficiently. I don't have a spare license, so I was wondering... if I installed MS SQL Server 2005 Express on my home machine, could I use it to effectively administrate the higher-end installations on our servers?
Also, if you have any trouble doing anything from Managment Studio Express, there are third-party tools out there that have no trouble connecting to SQL Server.
Personally, I've noticed a few things missing out of the box:
- Activity Monitor
- Job monitor
However, the question I linked to indicated you may be able to restore most of that for use when you connect to a full sql server edition.