CODEWITHSUNDEEP
sql-serverssms
Anonymous Cow
Anonymous Cow

Reputation:

Sql 05 express management studio versus standard

What are the differences between the free sql express 05 management studio and the licensed version?

Upvotes: 0

Views: 1700

Answers (2)

Scott Porad
Scott Porad

Reputation: 293

See the "SQL Server 2005 Features Comparison" at http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Upvotes: 0

Chris Lawlor
Chris Lawlor

Reputation: 48902

Management Studio Express cannot manage the following:

  • SQL Server Analysis Services
  • Integration Services
  • Notification Services
  • Reporting Services
  • SQL Server Agent
  • SQL Server 2005 Mobile Edition

( from this page. Look at the Note in the Overview section. )

These are all features that are not supported by SQL Server Express.

Also note that the full version of SQL Management Studio is included with SQL Server 2005.

Upvotes: 1

Related Questions