SQL Server Editions and Service Pack information
History
This is basic information of MS SQL Server 2012, 2008 R2, 2008, 2005, 2000, 7.0, 6.5 that have been released.
SQL Server is the product of Microsoft. We will have a look in brief description
More new features introduced in SQL Server 2005 version and vast 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
|
11.0.x.x
|
SQL Server 2012
|
10.5.x.x
|
SQL Server 2008 R2
|
10.00.x.x
|
SQL Server 2008
|
9.00.x.x
|
SQL Server 2005
|
8.00.x.x
|
SQL Server 2000
|
7.00.x.x
|
SQL Server 7.0
|
6.5.x.x
|
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 Server212 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 scale 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
|
codename
|
RTM (No SP)
|
SP1
|
SP2
|
SP3
|
SP4
|
SQL Server 2012
|
Denali
|
11.00.XX.XX
|
11.00.XX..
| |||
SQL Server 2008 R2
|
Kilimanjaro
|
10.50.XX.XX
|
10.50.XX ..
|
10.50.XX..
| ||
SQL Server 2008
|
Katmai
|
10.00.XX..
| ||||
SQL Server 2005
|
Yukon
|
9.00.XX..
| ||||
SQL Server 2000
|
Shiloh 32-Bit
Liberty 64-Bit
|
8.00.XX.
| ||||
SQL Server 7.0
|
Sphinx
|
7.00.XX..
| ||||
SQL Server 6.5
|
Hydra
|
6.5.XX..
|
6.50.XX
|
6.50.XX
|
6.50.XX..
|
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 . Happy Reading
No comments:
Post a Comment