Home / MSSQL DBA / SQL Server Editions and Service Pack information

SQL Server Editions and Service Pack information


SQL Server is the product of Microsoft To take advantage of this template’s design, use the Styles gallery on the Home tab. You can format your headings by using heading styles, or highlight important text using other styles, like Emphasis and Intense Quote. These styles come in formatted to look great and work together to help communicate your ideas.Go ahead and get started.
More new features introduced in SQL Server 2005 version and vast  of improvement.
T-SQL (Transaction SQL) enhancements
CLR (Common Language Runtime)
Service Broker
Data encryption
HTTP endpoints
Multiple Active Result Sets (MARS)
SQL Server Integration Services (SSIS)
Database mirroring
Snapshot isolation                    ….going back to Product versions
below following table as a reference for SQL versions.
Version pattern
SQL Product
SQL Server 2012
SQLServer 2008 R2
SQL Server 2008
SQL Server 2005
SQL Server 2000
SQL Server 7.0
SQL Server 6.5

History of Editions

Installation requirements based on your application needs. The different editions of SQL Server accommodate the performance, runtime, and price requirements of corporate organizations and small company. The SQL Server components that you install also depend on your specific requirements.
The following sections help you understand how to make the best choice among the editions and components available in SQL Server….
SQL Server 2000 Enterprise Edition
SQL Server 2000 Developer Edition
SQL Server 2000 Standard Edition
SQL Server 2000 Personal Edition
SQL Server 2000 Windows CE Edition
SQL Server 2000 Enterprise Evaluation Edition(Trail Version)
Enterprise Edition
Used as a production database server. Supports all features available and scales to the performance levels required to support the largest Web sites and enterprise online transaction processing (OLTP) and data warehousing systems. It’s Expensive comparing to all SQL Server versions.
Developer Edition
Used by programmers developing applications that uses SQL Server  as their data store. Although the Developer Edition supports all the features of the Enterprise Edition that allow developers to write and test applications that can use the features, The Developer Edition is licensed for use only as a development and test system, not a production server.
Standard Edition
Standard Edition for Small Business includes all of the technical components and capabilities and is licensed to operate in a small business environment
Personal Edition
Used by mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage. Also used when running a stand-alone application that requires local SQL Server data storage on a client computer.
Windows CE Edition
SQL Server CE is used as the data store on Windows CE devices. Capable of replicating data with any edition of SQL Server 2000 to keep Windows CE data synchronized with the primary database.
Enterprise Evaluation Edition
Full-featured version available by a free download from the Web. Intended only for use in evaluating the features of SQL Server; this version will expires after 120 days after downloading.
SQL Server 2005 Editions
SQL Server 2005 Enterprise Edition
SQL Server 2005 Developer Edition
SQL Server 2005 Standard Edition
SQL Server 2005 Work Group Edition
SQL Server 2005 Express Edition
SQL Server 2005 Express Edition with advanced Services
About all versions we discussed on above the document. we will have a look with work group and Express edition.
Express Edition
SQL Server Express or SQL Server Express with Advanced Services are having very limited features. SQL agent won’t available. Moreover it’s a Free Edition.
Work Group Edition
SQL Server Workgroup is ideal for running branch location databases providing a reliable data management. Useful for any small type of organization.
SQL Server 2008 Editions
SQL Server 2008 Enterprise Edition
SQL Server 2008 Developer Edition
SQL Server 2008 Standard Edition
SQL Server 2008 Work Group Edition
SQL Server 2008 Web Edition
SQL Server 2008 Express Edition
SQL Server 2008 Express Edition with advanced Services
SQL Server 2008 Compact Edition
Enterprise is available in SQL Server 2008 Enterprise Evaluation for a 180-day trial
About all versions we discussed on above the document.
SQL Server 2008 Web Edition
Web Edition is a low total-cost-of-ownership option for Web hosts and Web sites that provide scalability and manageability capabilities for small to large scale Web properties.
SQL Server 2008 Compact Edition
Compact Edition is a free version, embedded database ideal for building stand-alone and occasionally connected applications for mobile devices, desktops, and Web clients on all Windows environments.
SQL Server 2012 Editions
SQL Server 2012 Enterprise Edition
SQL Server 2012 Business Intelligence Edition New
SQL Server 2012 Standard Edition
SQL Server 2012 Web Edition
SQL Server 2012 Developer Edition
SQL Server 2012 Express Edition
Service Pack Summary and Code names
SQL Server 
SQL Server 2012
SQL Server 2008 R2
SQL Server 2008
SQL Server 2005
SQL Server 2000
Shiloh 32-Bit
Liberty 64-Bit
SQL Server 7.0
 SQL Server 6.5

Determine the version of SQL Server

Method  1:-

SQL Server Management Studio (SSMS)

To determine the version of the client tools that are installed on your system, start Management Studio, and then click About on the Help menu.
Method  2:-
Look at the first few lines of the Errorlog file for that instance. By default, the error log is located at Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n files.
Method 3:-
Connect to the instance of SQL Server, and then run the following query:
Select @@version
Method 4:-   run the following query on SSMS query builder:
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
These are the versions and editions about sql server .              
Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Check Also

SQL Server Error Logs

SQL Server Error Logs Detailed Information

SQL Server Error Logs * Error Logs maintains events raised by SQL Server server or …

Leave a Reply

Your email address will not be published. Required fields are marked *

Subscribe To Newsletter
Be the first to get latest updates and exclusive content straight to your email inbox.
Stay Updated
Give it a try, you can unsubscribe anytime.

Your information will never be shared
Sign-up for exclusive content. Be the first to hear about DBA Centre Blogs.