SQL Server Service Pack version query

24 July 2012 by

I was just checking the Service Pack versions on our SQL servers. Here’s the query I used:

SELECT
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('ProductVersion') AS ProductVersion

The Community Technology Preview (CTP) of SP2 for SQL Server 2008 is already out, so it shouldn’t be too long for general release, so in the meantime we’re up-to-date using SP1 🙂

SQL Server 2005 is at its latest Service Pack on version 4:

Standard Edition (64-bit) – SP4 – 9.00.5057.00

Related Posts:

  1. How to find out the Service Pack and Update Rollup versions in Exchange 2007 2010
  2. Using data and time in batch files
  3. vCenter Server Appliance Service fails after upgrading ESXi hosts to 5.0 U1 Veeam backups now fail
  4. Installing SQL Server 2008 R2
  5. Service Accent Error – Please wait a few minutes as another workstation is updating your database
Filed Under: Microsoft, SQL Server Tagged With: