question

pits avatar image
pits asked

version identification

Hello, where we can see sql version (2000,2005 or 2008) under sql server properties in management studio? Rgds,
sqlversionidentification
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

6 Answers

·
sp_lock avatar image
sp_lock answered
When you connect to the instance the version is displayed on the top node
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
Properties will show version number, for example 9.00.4060.00 for my SQL Server 2005 Developer Edition. The first digit reveals the major version: 8 = SQL Server 2000 9 = SQL Server 2005 9 = SQL Server 2008 I don't know if SQL Server 2008 R2 presents as 9.XX.YYYY.ZZ or 10.XX.YYYY.ZZ
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
2008 is 10.0, 2008 R2 is 10.5, interestingly Azure is (currently) 10.25
3 Likes 3 ·
Magnus Ahlkvist avatar image Magnus Ahlkvist commented ·
Thanks Kev. I also see I made a typo and gave both 2005 and 2008 major version 9.
1 Like 1 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
not quite - they simply indicate the build number - these can be checked here: - SQL2008R2 : - SQL2008 : - SQL2005 :
1 Like 1 ·
pits avatar image pits commented ·
thank you Magnus,Kev, The other digits after 8 or 9 or 10 stands for service pack or security pack...right? e.g 8.0.769 so it seems version 2000 and .0 and .769 stands for service pack or security pack, right?...the service pack 1=1399 , service pack 2=3042,service pack 3= 4053...how to identify service pack based on other digits other then the mentioned one.
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
Or open up a query window and run SELECT @@VERSION.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
It's shown under the version property ![alt text][1] [1]: /upfiles/PrtScr_1.jpg
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
here are two places ![alt text][1] [1]: /upfiles/SSMS_ServerVersions.png
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ramesh 1 avatar image
ramesh 1 answered
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') this quert result set gives you the complete details
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.