|
SQL Server 2012
|
||
|
11.0.2316
|
12 Apr 2012
|
|
|
11.0.2100.6
|
7 Mar 2012
|
|
|
SQL Server 2008 R2
|
||
|
10.50.2811
|
16 Apr 2012
|
|
|
10.50.2806
|
22 Feb 2012
|
|
|
10.50.2796
|
9 Jan 2012
|
|
|
10.50.2789.0
|
17 Oct 2011
|
|
|
10.50.2772.0
|
16 Aug 2011
|
|
|
10.50.2769.0
|
16 Sep 2011
|
|
|
10.50.2500.0
|
11 Jul 2011
|
|
|
10.50.1815
|
17 Apr 2012
|
|
|
10.50.1810
|
21 Feb 2012
|
|
|
10.50.1809
|
9 Jan 2012
|
|
|
10.50.1807.0
|
19 Oct 2011
|
|
|
10.50.1804.0
|
23 Aug 2011
|
|
|
10.50.1797.0
|
16 Sep 2011
|
|
|
10.50.1777.0
|
16 Jun 2011
|
|
|
10.50.1765.0
|
21 Feb 2011
|
|
|
10.50.1753.0
|
20 Dec 2010
|
|
|
10.50.1746.0
|
18 Oct 2010
|
|
|
10.50.1734.0
|
17 Aug 2010
|
|
|
10.50.1720.0
|
25 Jun 2010
|
|
|
10.50.1702.0
|
18 May 2010
|
|
|
10.50.1600.1
|
SQL Server 2008 R2 RTM
|
12 Apr 2010
|
|
SQL Server 2008
|
||
|
10.00.5775
|
20 Mar 2012
|
|
|
10.00.5770
|
16 Jan 2012
|
|
|
10.00.5768
|
22 Nov 2011
|
|
|
10.00.5766
|
18 Oct 2011
|
|
|
10.00.5500
|
6 Oct 2011
|
|
|
10.00.4330
|
19 Mar 2012
|
|
|
10.00.4326
|
30 Jan 2012
|
|
|
10.00.4323
|
21 Nov 2011
|
|
|
10.00.4321
|
20 Sep 2011
|
|
|
10.00.4316
|
18 Jul 2011
|
|
|
10.00.4285
|
16 May 2011
|
|
|
10.00.4279
|
21 Mar 2011
|
|
|
10.00.4272
|
17 Jan 2011
|
|
|
10.00.4266
|
15 Nov 2010
|
|
|
10.00.4000
|
29 Sep 2010
|
|
|
10.00.2850
|
19 Sep 2011
|
|
|
10.00.2847
|
18 Jul 2011
|
|
|
10.00.2816
|
22 Mar 2011
|
|
|
10.00.2812
|
16 May 2011
|
|
|
10.00.2808
|
17 Jan 2011
|
|
|
10.00.2804
|
15 Nov 2010
|
|
|
10.00.2799
|
21 Sep 2010
|
|
|
10.00.2789
|
19 Jul 2010
|
|
|
10.00.2775
|
17 May 2010
|
|
|
10.00.2766
|
15 Mar 2010
|
|
|
10.00.2757
|
18 Jan 2010
|
|
|
10.00.2746
|
24 Nov 2009
|
|
|
10.00.2734
|
22 Sep 2009
|
|
|
10.00.2723
|
21 Jul 2009
|
|
|
10.00.2714
|
18 May 2009
|
|
|
10.00.2710
|
16 Apr 2009
|
|
|
10.00.2531
|
7 Apr 2009
|
|
|
10.00.1835
|
15 Mar 2010
|
|
|
10.00.1828
|
18 Jan 2009
|
|
|
10.00.1823
|
16 Nov 2009
|
|
|
10.00.1818
|
21 Sep 2009
|
|
|
10.00.1812
|
21 Jul 2009
|
|
|
10.00.1806
|
18 May 2009
|
|
|
10.00.1798
|
17 Mar 2009
|
|
|
10.00.1787
|
19 Jan 2009
|
|
|
10.00.1779
|
17 Nov 2008
|
|
|
10.00.1763
|
22 Sep 2008
|
|
|
10.00.1600
|
SQL Server 2008 RTM
|
6 Aug 2008
|
|
SQL Server 2005
|
||
|
9.00.5266
|
21 Mar 2011
|
|
|
9.00.5259
|
22 Feb 2011
|
|
|
9.00.5254
|
20 Dec 2010
|
|
|
9.00.5000
|
17 Dec 2010
|
|
|
9.00.4325
|
21 Mar 2011
|
|
|
9.00.4317
|
21 Feb 2011
|
|
|
9.00.4315
|
20 Dec 2010
|
|
|
9.00.4311
|
18 Oct 2010
|
|
|
9.00.4309
|
17 Aug 2010
|
|
|
9.00.4305
|
23 Jun 2010
|
|
|
9.00.4294
|
19 Apr 2010
|
|
|
9.00.4285
|
16 Feb 2010
|
|
|
9.00.4273
|
21 Dec 2009
|
|
|
9.00.4266
|
19 Oct 2009
|
|
|
9.00.4230
|
17 Aug 2009
|
|
|
9.00.4226
|
16 Jun 2009
|
|
|
9.00.4220
|
21 Apr 2009
|
|
|
9.00.4211
|
17 Feb 2009
|
|
|
9.00.4207
|
20 Dec 2008
|
|
|
9.00.4053
|
13 Oct 2009
|
|
|
9.00.4035
|
16 Dec 2008
|
|
|
9.00.3356
|
21 Dec 2009
|
|
|
9.00.3355
|
19 Oct 2009
|
|
|
9.00.3330
|
18 Aug 2009
|
|
|
9.00.3328
|
16 Jun 2009
|
|
|
9.00.3325
|
21 Apr 2009
|
|
|
9.00.3315
|
17 Feb 2009
|
|
|
9.00.3310
|
10 Feb 2009
|
|
|
9.00.3301
|
SQL
Server 2005 SP2 CU11
|
15 Dec 2008
|
|
9.00.3294
|
20 Oct 2008
|
|
|
9.00.3282
|
18 Aug 2008
|
|
|
9.00.3257
|
16 Jun 2008
|
|
|
9.00.3239
|
14 Apr 2008
|
|
|
9.00.3233
|
SQL
Server 2005 QFE Security Hotfix
|
8 Jul 2008
|
|
9.00.3228
|
18 Feb 2008
|
|
|
9.00.3215
|
17 Dec 2007
|
|
|
9.00.3200
|
15 Oct 2007
|
|
|
9.00.3186
|
20 Aug 2007
|
|
|
9.00.3175
|
28 Jun 2007
|
|
|
9.00.3161
|
SQL
Server 2005 SP2 CU1
|
15 Apr 2007
|
|
9.00.3152
|
7 Mar 2007
|
|
|
9.00.3077
|
10 Feb 2009
|
|
|
9.00.3054
|
5 Apr 2007
|
|
|
9.00.3042.01
|
5 Mar 2007
|
|
|
9.00.3042
|
SQL
Server 2005 SP2
|
1 Feb 2007
|
|
9.00.2047
|
SQL Server 2005 SP1
|
|
|
9.00.1399
|
SQL Server 2005 RTM
|
1 Nov 2005
|
|
SQL Server 2000
|
||
|
8.00.2039
|
SQL
Server 2000 SP4
|
|
|
8.00.0760
|
SQL
Server 2000 SP3
|
|
|
8.00.0534
|
SQL
Server 2000 SP2
|
|
|
8.00.0384
|
SQL
Server 2000 SP1
|
|
|
8.00.0194
|
SQL
Server 2000 RTM
|
|
|
SQL Server 7
|
||
|
7.00.1063
|
SQL
Server 7 SP4
|
|
|
7.00.0961
|
SQL
Server 7 SP3
|
15 Dec 2000
|
|
7.00.0842
|
SQL
Server 7 SP2
|
20 Mar 2000
|
|
7.00.0699
|
SQL
Server 7 SP1
|
15 Jul 1999
|
|
7.00.0623
|
SQL
Server 7 RTM
|
|
|
SQL Server 6.5
|
||
|
6.50.416
|
SQL
Server 6.5 SP5a
|
|
|
6.50.415
|
SQL
Server 6.5 SP5
|
|
|
6.50.281
|
SQL
Server 6.5 SP4
|
|
|
6.50.258
|
SQL
Server 6.5 SP3
|
|
|
6.50.240
|
SQL
Server 6.5 SP2
|
|
|
6.50.213
|
SQL
Server 6.5 SP1
|
|
|
6.50.201
|
SQL
Server 6.5 RTM
|
|
Select @@version
@@Version is a system level variable that holds the current version. On my
computer this returns
Microsoft SQL Server 2000 - 8.00.384 (Intel X86)
May 23 2001
00:02:52
Copyright (c)
1988-2000 Microsoft Corporation
Standard
Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
The main version number is 8.00.384 which corresponds to SQL Server
2000 SP1. See below for a complete list of versions. It will also tell us the
version of the operating system we're running. In this case I'm running Windows
2000 (aka NT 5.0) Service Pack 2. You can find this same information in
Enterprise Manager by right clicking on a server and choosing Properties. The
version information is displayed in the General tab.This information is pulled from the system extended procedure
xp_msver.
You can call this stored procedure like
exec master..xp_msver
very use full information.
ReplyDelete