<< “System.OutOfMemoryException: Server Out Of Memory” while using SPLimitedWebPartManager, yet another instance of when you need to call .Dispose() on an SPWeb object | STSADM.EXE –o extendvs WEIRD issues >>

Which version of SQL Server am I running?

tony testa posted on September 4, 2009 00:45

I’ll fully admit that this is a dump from a MS KB page, but I can’t remember how many times I’ve had to search for this, so I figured I’d make a blog posting more for myself so that I can just come back to my own blog and know the info is here.

How to determine which version of SQL Server 2008 is running

To determine which version of Microsoft SQL Server 2008 is running, connect to SQL Server 2008 by using SQL Server Management Studio, and then run the following Transact-SQL statement.

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The following results are returned:

The product version (for example, 10.0.1600.22)
The product level (for example, RTM)
The edition (for example, Enterprise)

For example, the results resemble the following.

Collapse this tableExpand this table

10.0.1600.22
RTM
Enterprise Edition

The following table lists the Sqlservr.exe version number.

Collapse this tableExpand this table

Release
Sqlservr.exe

RTM
2007.100.1600.0

SQL Server 2008 Service Pack 1
2007.100.2531.0

How to determine which version of SQL Server 2005 is running

To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement.

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The following results are returned:

The product version (for example, 9.00.1399.06)
The product level (for example, RTM)
The edition (for example, Enterprise Edition)

For example, the results resemble the following.

Collapse this tableExpand this table

9.00.1399.06
RTM
Enterprise Edition

The following table lists the Sqlservr.exe version number.

Collapse this tableExpand this table

Release
Sqlservr.exe

RTM
2005.90.1399

SQL Server 2005 Service Pack 1
2005.90.2047

SQL Server 2005 Service Pack 2
2005.90.3042

SQL Server 2005 Service Pack 3
2005.90.4035

How to determine which version of SQL Server 2000 is running

To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code.

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The following results are returned:

The product version (for example, 8.00.534)
The product level (for example, "RTM" or "SP2")
The edition (for example, "Standard Edition"). For example, the results resemble the following:
8.00.534 SP2 Standard Edition

The following table lists the Sqlservr.exe version number.

Collapse this tableExpand this table

Release
Sqlservr.exe

RTM
2000.80.194.0

SQL Server 2000 SP1
2000.80.384.0

SQL Server 2000 SP2
2000.80.534.0

SQL Server 2000 SP3
2000.80.760.0

SQL Server 2000 SP3a
2000.80.760.0

SQL Server 2000 SP4
2000.8.00.2039

How to determine which version of SQL Server 7.0 is running

To determine which version of SQL Server 7.0 is running, connect to SQL Server 7.0 by using Query Analyzer, and then run the following code.

SELECT @@VERSION

The results resemble the following:

Microsoft SQL Server  7.00 - 7.00.623 (Intel X86)
        Nov 27 1998 22:20:07
        Copyright (c) 1988-1998 Microsoft Corporation
        Desktop Edition on Windows NT 5.1 (Build 2600: )

Note In this example, the version number is 7.00.623.
Use the version number in the following table to identify the product or service pack level.

Collapse this tableExpand this table

Version Number
Service Pack

7.00.1063
SQL Server 7.0 Service Pack 4 (SP4)

7.00.961
SQL Server 7.0 Service Pack 3 (SP3)

7.00.842
SQL Server 7.0 Service Pack 2 (SP2)

7.00.699
SQL Server 7.0 Service Pack 1 (SP1)

7.00.623
SQL Server 7.0 RTM (Release To Manufacturing)

If the version number that is reported by @@VERSION is not listed in this table, SQL Server is running with a hotfix or a security update build. For example, if @@VERSION reports a version number of 7.00.859, you are running SQL Server 7.0 SP2 with a hotfix installed. The version number increases with each new version of the Sqlservr.exe executable file. See to the Readme.txt file for your hotfix or security update for more information.

How to determine which version of SQL Server 6.5 is running

To determine which version of Microsoft SQL Server 6.5 is running, connect to SQL Server 6.5 by using Isql_w, and then run the following code.

SELECT @@VERSION

Use the version number in the following table to identify the product or service pack level.

Collapse this tableExpand this table

Version Number
Service Pack

6.50.479
SQL Server 6.5 Service Pack 5a (SP5a) Update

6.50.416
SQL Server 6.5 Service Pack 5a (SP5a)

6.50.415
SQL Server 6.5 Service Pack 5 (SP5)

6.50.281
SQL Server 6.5 Service Pack 4 (SP4)

6.50.258
SQL Server 6.5 Service Pack 3 (SP3)

6.50.240
SQL Server 6.5 Service Pack 2 (SP2)

6.50.213
SQL Server 6.5 Service Pack 1 (SP1)

6.50.201
SQL Server 6.5 RTM

If the version number that is reported by @@VERSION is not listed in this table, SQL Server is running with a hotfix or a security update build. The version number increases with each new version of the Sqlservr.exe executable file. See to the Readme.txt file for your hotfix or security update for more information.

How to determine which edition of SQL Server is running

If you are not sure about what edition of SQL Server that you are running, the last line of output that is returned by @@VERSION reports the edition to which you have connected. The example that is used in this article is the Standard Edition of SQL Server 2000 on Windows NT 5.0 (Build 2195: Service Pack 2).
Note The build and service pack information that is provided earlier is for the operating system, not for SQL Server.

Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)

Posted in: Tags:

Actions: E-mail | Permalink | Comments (45) | Comment RSS RSS comment feed

| E-mail | Kick it! | DZone it! | del.icio.us

3f2e0892-4a4d-464a-a37b-e40ec29f2ba0|0|.0

SQL Server Error 4064: Error message when you connect to an instance of SQL Server: "Cannot open user default database"I was doing a SharePoint reinstall at a client site today and was clearing out some of the databases...HowTo: SubSonic IntroductionUpdated 01/29/2008 Why Another SubSonic Introduction Blog Posting?: In my ever growing quest for p...How to transform a .NET DataSet returned from a web service with XSLHow to use XSL transform to parse .NET DataSet returned from a web service

Comments

payday online

September 14. 2009 01:04

I havent any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us.

http://www.yesmyloans.com/http://www.yesmyloans.com/

payday online

September 14. 2009 01:05

I havent any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us.

http://www.yesmyloans.com/http://www.yesmyloans.com/

payday online

September 14. 2009 01:06

I havent any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us.

http://www.yesmyloans.com/http://www.yesmyloans.com/

payday online

September 14. 2009 01:07

I havent any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us.

http://www.yesmyloans.com/http://www.yesmyloans.com/

payday online

September 14. 2009 01:08

I havent any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us.

http://www.yesmyloans.com/http://www.yesmyloans.com/

payday online

September 14. 2009 01:09

I havent any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us.

http://www.yesmyloans.com/http://www.yesmyloans.com/

payday loans

September 20. 2009 16:18

We are a group of volunteers and starting a new initiative in a community. Your blog provided us valuable information to work on.You have done a marvellous job!

http://www.easyfaxlesspaydayloan.com/http://www.easyfaxlesspaydayloan.com/

payday loans

September 20. 2009 16:19

We are a group of volunteers and starting a new initiative in a community. Your blog provided us valuable information to work on.You have done a marvellous job!

http://www.easyfaxlesspaydayloan.com/http://www.easyfaxlesspaydayloan.com/

payday loans

September 20. 2009 16:19

We are a group of volunteers and starting a new initiative in a community. Your blog provided us valuable information to work on.You have done a marvellous job!

http://www.easyfaxlesspaydayloan.com/http://www.easyfaxlesspaydayloan.com/

payday loans

September 20. 2009 16:20

We are a group of volunteers and starting a new initiative in a community. Your blog provided us valuable information to work on.You have done a marvellous job!

http://www.easyfaxlesspaydayloan.com/http://www.easyfaxlesspaydayloan.com/

payday loans

September 20. 2009 16:20

We are a group of volunteers and starting a new initiative in a community. Your blog provided us valuable information to work on.You have done a marvellous job!

http://www.easyfaxlesspaydayloan.com/http://www.easyfaxlesspaydayloan.com/

payday loans

September 20. 2009 16:20

We are a group of volunteers and starting a new initiative in a community. Your blog provided us valuable information to work on.You have done a marvellous job!

http://www.easyfaxlesspaydayloan.com/http://www.easyfaxlesspaydayloan.com/

hard drive recovery

September 30. 2009 18:17

Useful and nice information

http://www.stellarinfo.com/download.htmhttp://www.stellarinfo.com/download.htm

payday loan

September 30. 2009 20:31

verry usefull info, thanks
<a href="http://www.hourlyloan.com ">payday loans</a> are a great way to get a quick loan

http://www.hourlyloan.com/http://www.hourlyloan.com/

Hannah Louise

October 20. 2009 02:32

I recently figuring how can I determine which version of SQL Server 2008 is running$ and I am very glad that I found the answer here in your site. Thanks.

http://hannahlouise667.vox.com/http://hannahlouise667.vox.com/

Annuities

October 22. 2009 20:54

Cool. i know how to do this in MySql. Is there any special table on MS SQL which contain all these info?

http://www.freeannuityrates.com/http://www.freeannuityrates.com/

Cialis Online

October 24. 2009 04:19

Hell to the yeah!! merci

http://www.buy-specialist.com/http://www.buy-specialist.com/

online backup service

October 31. 2009 18:30

You really make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complicated and very broad for me. I am looking forward for your next post, I will try to get the hang

http://www.vaultonline.com.au/http://www.vaultonline.com.au/

www.1to101.com

November 2. 2009 01:48

Keep 'em coming... you all do such a great job at such Concepts... can't tell you how much I, for one appreciate all you do!

http://1to101.com/http://1to101.com/

google sniper review

November 3. 2009 01:56

I personally have embraced the new technologies and the CMS platforms, I think the new tools only make the web designs better. I am glad that new technologies are coming out in web design that make things easier, improved, and better looking for design.

http://googlesniperreview.com/http://googlesniperreview.com/

faxless payday loans

November 4. 2009 03:08

Hmmm interesting stuff

http://www.usapaydayloan.net/http://www.usapaydayloan.net/

mobile home loan

November 4. 2009 08:38

I must admit that this is one great insight. It surely gives a company the opportunity to get in on the ground floor and really take part in creating something special and tailored to their needs.

http://www.mobilehomemavericks.com/http://www.mobilehomemavericks.com/

larp swords

November 5. 2009 17:57

This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work.

http://www.larpdirect.com/larp-swords.htmlhttp://www.larpdirect.com/larp-swords.html

weight loss tips for women

November 6. 2009 08:24

Pretty technical stuff on SQL server if you ask me. Probably more info than I really needed to know, but thanks anyway.

http://weightlossgo.com/http://weightlossgo.com/

freight forwarders usa

November 6. 2009 08:27

Well, you totally got me there. SQL is not my favorite topic these days but that was a good stab at trying to figure it out.

http://forwardersins.com/http://forwardersins.com/

handicapped

November 6. 2009 08:38

Thanks for explaining that in a way that even I can understand. Much appreciated!

http://blogsubway.com/handicapped/http://blogsubway.com/handicapped/

benefits of green tea

November 6. 2009 20:57

Useful information shared..Iam very happy to read this article..thanks for giving us nice info.Fantastic walk-through. I appreciate this post.

http://green-tea-health-benefits.greenteaweightloss.net/http://green-tea-health-benefits.greenteaweightloss.net/

Natures Sunshine

November 6. 2009 22:21

I completely agree with the above comment, the internet is with a doubt growing into the most important medium of communication across the globe and its due to sites like this that ideas are spreading so quickly.

http://www.herbaldistributor.co.nz/http://www.herbaldistributor.co.nz/

agility equipment for dogs

November 7. 2009 04:33

I admire the valuable information you offer in your articles. I will bookmark your blog and have my children check up here often. I am quite sure they will learn lots of new stuff here than anybody else!

http://agilityequipmentfordogs.com/http://agilityequipmentfordogs.com/

freight service

November 10. 2009 19:46

Over time, demand for a new type of representative courier has emerged. With the increase in fuel prices and productivity goals monitored closely by companies, this new type of all-in-one courier has developed to "take care of business". Workers in companies have more work and less time to be out of the office. Operating largely using independent contractors that have gone through a screening process and background checks have found a niche in the courier industry. Research, intransit pet care, complex paperwork filing, and a host of other services are now offered in this new category of courier service.

http://www.e-go.com.au/http://www.e-go.com.au/

Ultimate WoW Leveling Guide

November 10. 2009 23:07

I’ll fully admit that this is a dump from a MS KB page, but I can’t remember how many times I’ve had to search for this, so I figured I’d make a blog posting more for myself

http://www.wowlevelupguide.com/DugisGuide.htmlhttp://www.wowlevelupguide.com/DugisGuide.html

winning at poker games

November 19. 2009 20:50

Thank you for the work you have put into this post, it helps clear up some questions I had.I will bookmark your blog because your posts are very informative.We appreciate your posts and look forward to coming back.

http://www.worldpokerpages.com/http://www.worldpokerpages.com/

Nye County Marriage Records

November 23. 2009 11:25

We sincerely got a kick out of your article. It seems that you've put a lot of effort into your web post and this world require much more of these on the web these days. I don't have a large amount to say in response, I just wanted to register to reply well done.

http://www.zimbio.com/Free+Criminal+Background+Check/articles/mH4h2o6NoGQ/Nye+County+Marriage+Recordshttp://www.zimbio.com/Free+Criminal+Background+Check/articles/mH4h2o6NoGQ/Nye+County+Marriage+Records

payday loans

January 25. 2010 07:19