verify version of MS sql

I have several servers running MS SQL Server 2008. How do I verify what patch level its running? If I go into add remove programs there is no version listed for Microsoft SQL Server 2008 but there is a version for all other things listed as MS SQL Server 2008 such as Browser, Native Client, extt. all those versions are the same. Do those versions represent what version Im running? If I go in to Managment studio and go to help it gives me versions for several things but not SQL server
bankadminAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Brian CroweDatabase AdministratorCommented:
SELECT @@VERSION

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Steve WalesSenior Database AdministratorCommented:
And you can then look up the number returned against this list to work out what the SP or Cum Patch level is: http://sqlserverversions.blogspot.com/

(It's not MS official but it's been there for years and is still maintained at the moment as far as I know)
bankadminAuthor Commented:
Where do I select Version from?
Build an E-Commerce Site with Angular 5

Learn how to build an E-Commerce site with Angular 5, a JavaScript framework used by developers to build web, desktop, and mobile applications.

Steve WalesSenior Database AdministratorCommented:
There is no from.  Just run "Select @@version"

SQL Server doesn't always require a FROM when querying certain items about the server or database.

(For example, you can also do:  SELECT getdate()   - that will return the date)
Olaf DoschkeSoftware DeveloperCommented:
It's the @@Version system variable, that is holding the version info. You wouldn't need SELECT, but it is the simplest way to return a query result. If you like you could also create a scalar function and return @@Version, but there is no point in doing that, if it's much simpler to do SELECT @@Version.

The T-SQL help topic on @@Server also refers to SERVERPROPERTY, see
https://msdn.microsoft.com/en-us/library/ms174396.aspx 
You may use that to get more detailed single infos. Look out some properties only exist from SQL 2012 onwards.

And there are more methods, eg see https://support.microsoft.com/en-us/kb/321185

If you see suspicious database behaviour or miss something, check out the compatibility level of a database by querying

SELECT name, compatibility_level FROM sys.databases

Open in new window


Also see https://msdn.microsoft.com/en-us/library/bb510680.aspx
bankadminAuthor Commented:
I logged into managment studio and executed the select @@VERSION command and it just sits on Debugging Query in a yellow bar in the window, in the same yellow bar it states servername (10.0 SP3).. Is that the version? Thanks for helping this SQL novice thru this.
Steve WalesSenior Database AdministratorCommented:
How did you Execute it ?  Debugging query sounds weird ?

You should just be able to open Management Studio.  Click New Query.  In the query window "select @@version" then Control-E to Execute.

The output that appears on one server of mine (it's an old one, don't laugh):

Microsoft SQL Server 2005 - 9.00.5324.00 (X64)   Aug 24 2012 18:28:47   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1)

Looking up that build number (9.00.5324) on that site I linked earlier - I found it wasn't listed!

Had to do some digging but found this:
http://www.sqlservercentral.com/articles/Administration/2960/

Which tells me that it's "MS12-070: Description of the security update for SQL Server 2005 Service Pack 4 QFE: October 9, 2012 "

You should be able to follow a similar procedure to get output and decode it.
Olaf DoschkeSoftware DeveloperCommented:
Seems you clicked on the green play symbol, that's starting a debug process. You need to click the Exclamation point or "Execute" or use CTRL+E to execute.

Just wait for the tooltip texts before you click on icons, as intuitive as they may look. And if something unexpected happend, well, it was not inituitive.

As you mention 10.0 SP3, this reminds me: the SQL Server version roughly is already shown, when you connect to a server in the object explorer root node in paranthesis after the server name,

Bye, Olaf.
Jose TorresCertified Database AdministratorCommented:
If you have ssms
1. Connect to the server
2. On the server it will tell you the build (refer to image)
SSMS Build3. Go to this site and it will tell you which SP you are on based on the build
http://sqlserverbuilds.blogspot.com/
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.