What are the differences between the free sql express 05 management studio and the licensed version?
A:
See the "SQL Server 2005 Features Comparison" at http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Scott Porad
2008-10-01 19:04:27
This link points to a table describing the differences between SQL Server and SQL Server Express - the database itself, not the Management Studio that the question is regarding
Chris Lawlor
2008-10-01 19:26:17
+1
A:
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.
Chris Lawlor
2008-10-01 19:26:30