Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

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.
0
ksfok
Asked:
ksfok
  • 4
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
SELECT SERVERPROPERTY('ProductLevel')  
that will give you the sp installed

2008 has SP1
0
 
ksfokAuthor Commented:
SELECT SERVERPROPERTY('ProductLevel')  
yields:
RTM
What is that? Thanks.
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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
 
Aneesh RetnakaranDatabase 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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now