Solved

SQL Server 2008 dev sevice pack check

Posted on 2009-07-08
6
303 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

821 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