SQL Server 2008 dev sevice pack check

What is the last  SQL Server 2008 sevice pack? How can I verify if my SQL2008 dev has the lastest sp?
Thanks.
ksfokAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
RTM,  means the release to manufacturung edition, it is the first realease, you never installed a service pack
In case you have installed a service pack say SP2 the above query would have returned  SP2
 
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
SELECT SERVERPROPERTY('ProductLevel')  
that will give you the sp installed

2008 has SP1
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
ksfokAuthor Commented:
SELECT SERVERPROPERTY('ProductLevel')  
yields:
RTM
What is that? Thanks.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
that will return the SP version if instlled (any) otherwise shows  RTM
0
 
ksfokAuthor Commented:
SQLServer2008SP1-KB968369-IA64-ENU.exe   312.9 MB Download
SQLServer2008SP1-KB968369-x64-ENU.exe     323.8 MB Download
SQLServer2008SP1-KB968369-x86-ENU.exe     262.7 MB
Which one of the above should I pick? My SQL2008 is running under WIN XP Pro.
 
0
All Courses

From novice to tech pro — start learning today.