Solved

SQL Server 2008 dev sevice pack check

Posted on 2009-07-08
6
300 Views
Last Modified: 2012-05-07
What is the last  SQL Server 2008 sevice pack? How can I verify if my SQL2008 dev has the lastest sp?
Thanks.
0
Comment
Question by:ksfok
  • 4
  • 2
6 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24804798
SELECT SERVERPROPERTY('ProductLevel')  
that will give you the sp installed

2008 has SP1
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24804803
0
 

Author Comment

by:ksfok
ID: 24804962
SELECT SERVERPROPERTY('ProductLevel')  
yields:
RTM
What is that? Thanks.
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24805037
that will return the SP version if instlled (any) otherwise shows  RTM
0
 

Author Comment

by:ksfok
ID: 24805210
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
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 24810511
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question