Post reply

Differences between Management Studio and Management Studio Express?

  • 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

  • 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.

  • 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.

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply