About SQL Server 2005 Service Packs

Last night I installed Microsoft BizTalk Server 2006 R2.

Though, during the configuration process of BizTalk, I was prompt that SQL Server 2005 Service Packs were not detected.

At that time I though to myself; how do I find if any, and which Service Pack is installed for SQL Server?

By reading the Microsoft Help and Support Article on the following link I solved my question:


In the article I found that I just had to execute the following query in my SQL Server Instance:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')


The first column presents the product version for SQL Server, the second presents the product level (i.e. RTM, SP1, SP2, etc) and the third column presents the edition of the installed SQL Server (i.e. Developer Edition).

The product level column was empty 🙂 To this end I directly proceeded with installing SP2 and continued with the configuration of BizTalk Server.

Anyhow, Service Pack 3 for SQL Server 2005 was released on December 15th 2008 so I guess I have to install this as well! 🙂

On the following link you can find information on how to obtain the latest Service Pack for SQL Server 2005:



Learn More Tips like this – Enroll to the Course!

Check our online course on Udemy titled “Essential SQL Server Administration Tips(special limited-time discount included in link).

Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!

Essential SQL Server Administration Tips - Online Course with Live Demonstrations and Hands-on Guides
(Lifetime Access/ Live Demos / Downloadable Resources and more!)

Learn More


Upgrade your Tech Skills – Learn all about Azure SQL Database

Enroll to our online course on Udemy titled “Introduction to Azure SQL Database for Beginners” and get lifetime access to high-quality lessons and hands-on guides about all aspects of Azure SQL Database.

Introduction to Azure SQL Database (Online Course - Lifetime Access)
(Lifetime Access/ Live Demos / Downloadable Resources and more!)
Learn More


Featured Online Courses:


Read Also


Check our Database Security and Administration Tool: DBA Security Advisor

DBA Security Advisor: Secure your SQL Server instances by scanning multiple instances against a rich set of security checks, and by getting recommendations and remediation steps.

DBA Security Advisor - SQL Server Security and Administration Tool

Learn more



Subscribe to our newsletter and stay up to date!

Subscribe to our YouTube channel (SQLNetHubTV)!

Like our Facebook Page!

Check our SQL Server Administration articles.

Check out our latest software releases!

Check our eBooks!

Benchmark SQL Server memory-optimized tables with In-Memory OLTP Simulator.



Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)


Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub