Skip to main content

SQL Server Versions, Service Pack and Codes

SQL Server Versions and Code Names :-


VersionYearRelease NameCodename
1.0
(OS/2)
1989SQL Server 1.0
(16bit)
-
1.1
(OS/2)
1991SQL Server 1.1
(16bit)
-
4.21
(WinNT)
1993SQL Server 4.21SQLNT
6.01995SQL Server 6.0SQL95
6.51996SQL Server 6.5Hydra
7.01998SQL Server 7.0Sphinx
-1999SQL Server 7.0
OLAP Tools
Plato
8.02000SQL Server 2000Shiloh
8.02003SQL Server 2000
64-bit Edition
Liberty
9.02005SQL Server 2005Yukon
10.02008SQL Server 2008Katmai
10.252010SQL Azure DBCloudDB
10.52010SQL Server 2008 R2Kilimanjaro (aka KJ)
11.02012SQL Server 2012Denali

Version with Service Packs...


SQL Server 2012
11.0.2316SQL Server 2012 CU112 Apr 2012
11.0.2100.6SQL Server 2012 RTM7 Mar 2012
SQL Server 2008 R2
10.50.2811SQL Server 2008 R2 SP1 CU616 Apr 2012
10.50.2806SQL Server 2008 R2 SP1 CU522 Feb 2012
10.50.2796SQL Server 2008 R2 SP1 CU49 Jan 2012
10.50.2789.0SQL Server 2008 R2 SP1 CU317 Oct 2011
10.50.2772.0SQL Server 2008 R2 SP1 CU216 Aug 2011
10.50.2769.0SQL Server 2008 R2 SP1 CU116 Sep 2011
10.50.2500.0SQL Server 2008 R2 SP111 Jul 2011
10.50.1815SQL Server 2008 R2 CU1317 Apr 2012
10.50.1810SQL Server 2008 R2 CU1221 Feb 2012
10.50.1809SQL Server 2008 R2 CU119 Jan 2012
10.50.1807.0SQL Server 2008 R2 CU1019 Oct 2011
10.50.1804.0SQL Server 2008 R2 CU923 Aug 2011
10.50.1797.0SQL Server 2008 R2 CU816 Sep 2011
10.50.1777.0SQL Server 2008 R2 CU716 Jun 2011
10.50.1765.0SQL Server 2008 R2 CU621 Feb 2011
10.50.1753.0SQL Server 2008 R2 CU520 Dec 2010
10.50.1746.0SQL Server 2008 R2 CU418 Oct 2010
10.50.1734.0SQL Server 2008 R2 CU317 Aug 2010
10.50.1720.0SQL Server 2008 R2 CU225 Jun 2010
10.50.1702.0SQL Server 2008 R2 CU118 May 2010
10.50.1600.1SQL Server 2008 R2 RTM12 Apr 2010
SQL Server 2008
10.00.5775SQL Server 2008 SP3 CU420 Mar 2012
10.00.5770SQL Server 2008 SP3 CU316 Jan 2012
10.00.5768SQL Server 2008 SP3 CU222 Nov 2011
10.00.5766SQL Server 2008 SP3 CU118 Oct 2011
10.00.5500SQL Server 2008 SP36 Oct 2011
10.00.4330SQL Server 2008 SP2 CU919 Mar 2012
10.00.4326SQL Server 2008 SP2 CU830 Jan 2012
10.00.4323SQL Server 2008 SP2 CU721 Nov 2011
10.00.4321SQL Server 2008 SP2 CU620 Sep 2011
10.00.4316SQL Server 2008 SP2 CU518 Jul 2011
10.00.4285SQL Server 2008 SP2 CU416 May 2011
10.00.4279SQL Server 2008 SP2 CU321 Mar 2011
10.00.4272SQL Server 2008 SP2 CU217 Jan 2011
10.00.4266SQL Server 2008 SP2 CU115 Nov 2010
10.00.4000SQL Server 2008 SP229 Sep 2010
10.00.2850SQL Server 2008 SP1 CU1619 Sep 2011
10.00.2847SQL Server 2008 SP1 CU1518 Jul 2011
10.00.2816SQL Server 2008 SP1 CU1322 Mar 2011
10.00.2812SQL Server 2008 SP1 CU1416 May 2011
10.00.2808SQL Server 2008 SP1 CU1217 Jan 2011
10.00.2804SQL Server 2008 SP1 CU1115 Nov 2010
10.00.2799SQL Server 2008 SP1 CU1021 Sep 2010
10.00.2789SQL Server 2008 SP1 CU919 Jul 2010
10.00.2775SQL Server 2008 SP1 CU817 May 2010
10.00.2766SQL Server 2008 SP1 CU715 Mar 2010
10.00.2757SQL Server 2008 SP1 CU618 Jan 2010
10.00.2746SQL Server 2008 SP1 CU524 Nov 2009
10.00.2734SQL Server 2008 SP1 CU422 Sep 2009
10.00.2723SQL Server 2008 SP1 CU321 Jul 2009
10.00.2714SQL Server 2008 SP1 CU218 May 2009
10.00.2710SQL Server 2008 SP1 CU116 Apr 2009
10.00.2531SQL Server 2008 SP17 Apr 2009
10.00.1835SQL Server 2008 RTM CU1015 Mar 2010
10.00.1828SQL Server 2008 RTM CU918 Jan 2009
10.00.1823SQL Server 2008 RTM CU816 Nov 2009
10.00.1818SQL Server 2008 RTM CU721 Sep 2009
10.00.1812SQL Server 2008 RTM CU621 Jul 2009
10.00.1806SQL Server 2008 RTM CU518 May 2009
10.00.1798SQL Server 2008 RTM CU417 Mar 2009
10.00.1787SQL Server 2008 RTM CU319 Jan 2009
10.00.1779SQL Server 2008 RTM CU217 Nov 2008
10.00.1763SQL Server 2008 RTM CU122 Sep 2008
10.00.1600SQL Server 2008 RTM6 Aug 2008
SQL Server 2005
9.00.5266SQL Server 2005 SP4 CU321 Mar 2011
9.00.5259SQL Server 2005 SP4 CU222 Feb 2011
9.00.5254SQL Server 2005 SP4 CU120 Dec 2010
9.00.5000SQL Server 2005 SP417 Dec 2010
9.00.4325SQL Server 2005 SP3 CU1521 Mar 2011
9.00.4317SQL Server 2005 SP3 CU1421 Feb 2011
9.00.4315SQL Server 2005 SP3 CU1320 Dec 2010
9.00.4311SQL Server 2005 SP3 CU1218 Oct 2010
9.00.4309SQL Server 2005 SP3 CU1117 Aug 2010
9.00.4305SQL Server 2005 SP3 CU1023 Jun 2010
9.00.4294SQL Server 2005 SP3 CU919 Apr 2010
9.00.4285SQL Server 2005 SP3 CU816 Feb 2010
9.00.4273SQL Server 2005 SP3 CU721 Dec 2009
9.00.4266SQL Server 2005 SP3 CU619 Oct 2009
9.00.4230SQL Server 2005 SP3 CU517 Aug 2009
9.00.4226SQL Server 2005 SP3 CU416 Jun 2009
9.00.4220SQL Server 2005 SP3 CU321 Apr 2009
9.00.4211SQL Server 2005 SP3 CU217 Feb 2009
9.00.4207SQL Server 2005 SP3 CU120 Dec 2008
9.00.4053SQL Server 2005 SP3 GDR (Security Update)13 Oct 2009
9.00.4035SQL Server 2005 SP316 Dec 2008
9.00.3356SQL Server 2005 SP2 CU1721 Dec 2009
9.00.3355SQL Server 2005 SP2 CU1619 Oct 2009
9.00.3330SQL Server 2005 SP2 CU1518 Aug 2009
9.00.3328SQL Server 2005 SP2 CU1416 Jun 2009
9.00.3325SQL Server 2005 SP2 CU1321 Apr 2009
9.00.3315SQL Server 2005 SP2 CU1217 Feb 2009
9.00.3310SQL Server 2005 SP2 Security Update10 Feb 2009
9.00.3301SQL Server 2005 SP2 CU1115 Dec 2008
9.00.3294SQL Server 2005 SP2 CU1020 Oct 2008
9.00.3282SQL Server 2005 SP2 CU918 Aug 2008
9.00.3257SQL Server 2005 SP2 CU816 Jun 2008
9.00.3239SQL Server 2005 SP2 CU714 Apr 2008
9.00.3233SQL Server 2005 QFE Security Hotfix8 Jul 2008
9.00.3228SQL Server 2005 SP2 CU618 Feb 2008
9.00.3215SQL Server 2005 SP2 CU517 Dec 2007
9.00.3200SQL Server 2005 SP2 CU415 Oct 2007
9.00.3186SQL Server 2005 SP2 CU320 Aug 2007
9.00.3175SQL Server 2005 SP2 CU228 Jun 2007
9.00.3161SQL Server 2005 SP2 CU115 Apr 2007
9.00.3152SQL Server 2005 SP2 Cumulative Hotfix7 Mar 2007
9.00.3077SQL Server 2005 Security Update10 Feb 2009
9.00.3054SQL Server 2005 KB9344585 Apr 2007
9.00.3042.01SQL Server 2005 "SP2a"5 Mar 2007
9.00.3042SQL Server 2005 SP21 Feb 2007
9.00.2047SQL Server 2005 SP1
9.00.1399SQL Server 2005 RTM1 Nov 2005
SQL Server 2000
8.00.2039SQL Server 2000 SP4
8.00.0760SQL Server 2000 SP3
8.00.0534SQL Server 2000 SP2
8.00.0384SQL Server 2000 SP1
8.00.0194SQL Server 2000 RTM
SQL Server 7
7.00.1063SQL Server 7 SP4
7.00.0961SQL Server 7 SP315 Dec 2000
7.00.0842SQL Server 7 SP220 Mar 2000
7.00.0699SQL Server 7 SP115 Jul 1999
7.00.0623SQL Server 7 RTM
SQL Server 6.5
6.50.416SQL Server 6.5 SP5a
6.50.415SQL Server 6.5 SP5
6.50.281SQL Server 6.5 SP4
6.50.258SQL Server 6.5 SP3
6.50.240SQL Server 6.5 SP2
6.50.213SQL Server 6.5 SP1
6.50.201SQL Server 6.5 RTM

Comments

Popular posts from this blog

mongoDB error : aborting after fassert() failure

What to do when facing errors on mongoDB “aborting after fassert() failure”

I like errors, in mongoDB this is the first error I faced and luckily many times. This error i faced during restoring name-space on local and restarting db system. I am still searching the exact root cause of this issue but i am able to resolve the current problem through below steps.

Remove all relevant namespace files from data-file route path..Now repair mongo instance using mongod process.mongod --repair ////////// execute command from bin folder path Then start server using mongd process, if started server successfully then ..mongod  ////////// execute command from bin folder path Restore last backups as normal process.Now check database by connecting mongo shell. Thanks for reading, 
Please comment your experience if you faced and also share knowledge if you have better steps to resolve...


https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

SQL71562: external references are not supported when creating a package from this platform

Last week I got this error from one of developer who was trying to deploy his project from Testing server to SQL Azure QA server. He was using “Deploy Database to SQL Azure” option from SSMS Tool-Task option.

After connecting to SQL Azure portal when operation started to deployment below errors occurs.

Validation of the schema model for data package failed. Error SQL71562: Error validating element xx.xxx.xx:function .dbo.xxx has an unresolved refrence to object xx.dbo.xxxx external refrences are not supported when creating a package from this platform.



Reason: The reason of the this error was; some functions of project was dependent on master database and only single database was being deploy to SQL Azure. DACFx must block Export when object definitions (views, procedures, etc.) contain external references, as Azure SQL Database does not allow cross-database external references So, this error was coming.

Solution : I suggested him to create those function to locally on local database what…

How to add an article in Transactional Replication

If we have a set-up of Transactional Replication for Data Distribution running and wanting to add new object to replication on other server we can follow below process.
To add an article In Transaction replication with PUSH Subscription