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?

Answers


See this question: http://stackoverflow.com/questions/117347/whats-the-difference-between-sql-server-management-studio-and-the-express-versi

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:

  • Import/Export
  • 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.


Need Your Help

NSURLConnection sendAsynchronousRequest and NSURLConnection initWithRequest return different data

iphone objective-c ipad nsurlconnection

I was using [NSURLConnection sendAsynchronousRequest:req queue:[NSOperationQueue mainQueue] completionHandler:^(NSURLResponse *response, NSData *data, NSError *error) {}] to return some XML dat...

Using geolocalisation with windows phone, await error

asynchronous geolocation windows-phone-8 async-await

I'm trying to get the current location of an user, but the code show me an error...

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.