Differences between Management Studio and Management Studio Express?

• Chris Lewis-136425

  SSC Veteran

  Points: 267

  More actions

  November 8, 2006 at 9:07 am

  #115042

  Are there any differences between Management Studio and Management Studio Express?  I ask because I'm able to see SQL Agent in the object explorer and view error logs in Management Studio, but not in Express.  MS is installed on the server, and MSE is on my PC.  I using version 9.00.2047.00 on each machine and I'm using the same login credentials. 

  Thanks in advance...Chris

• Andy B.

  SSC Eights!

  Points: 890

  More actions

  November 8, 2006 at 10:16 pm

  #670763

  Unfortunately, one of the big let downs of SQL Express is that there is no agent.

  For a more complete list of differences check here:

  http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

  
  Enjoy!
  
  A Brown
  
  Manage all of your backups in one simple job using this script.

• AndrewM-375946

  Right there with Babe

  Points: 717

  More actions

  November 9, 2006 at 7:27 am

  #670832

  Ive found you can get more functionality out of MSDE 2000 than sql express 20005, especially due to there being no agent on 2005.

• mattyk6

  Ten Centuries

  Points: 1152

  More actions

  November 10, 2006 at 12:07 pm

  #671164

  Management Studio Express is the free tool that MS supplied to work with SQL Server Express.

  Management Studio is the tool that comes with the other editions of SQL Server; Workgroup, Standard, Enterprise, and Developer.