About Sql Server 2005

Microsoft SQL Server is a relational database management system developed by Microsoft. SQL Server 2005 was released in October 2005. It is the successor of the Microsoft SQL Server 2000. Microsoft SQL Server 2005 extends the performance, reliability, availability, programmability, and ease-of-use of SQL Server 2000. The following are the enhancements in SQL server 2005:

  • Notification Services Enhancements
  • Reporting Services Enhancements
  • New Service Broker
  • Database Engine Enhancements
  • Data Access Interfaces Enhancements
  • Analysis Services Enhancements
  • Integration Services Enhancements
  • Full-Text Search Enhancements
  • Notification Services Enhancements
  • Replication Enhancements
  • Reporting Services Enhancements
  • Tools and Utilities Enhancements

There are the following editions of Microsoft SQL Server 2005 are available :

  • SQL Server 2005 Express Edition
  • SQL Server 2005 Workgroup Edition
  • SQL Server 2005 Enterprise Edition
  • SQL Server 2005 Developer Edition
  • SQL Server 2005 Standard Edition
  • SQL Server 2005 Mobile Edition


SQL Server 2005 Express Edition


SQL Server Express is a FREE product from Microsoft with the limited features.

  • Programmability Features
  • (such as CLR integration,User-defined Aggregates,functions and datatypes,Extended Triggers)

  • Data protection.
  • Performance for embedded application clients.
  • Light weight applications and query editing tool.
  • Local data stores.
  • Royalty-free distribution
  • XML Support
  • Deep integration with Visual Studio 2005 etc.

Feature are not in Express Edition:

  • Analysis Services Features
  • Reporting Services Features
  • Notification Services Features
  • Integration Services Features
  • Replication Features
  • WMI Configuration Provider
  • Design Tools (such as Query designer,Query editor,MDX Query Editor etc.)
  • Table and Index Partitioning
  • Manageability Features