How to Read SQL Server 2005 Version(How to Know Which Service Pack Installed)
----In SQL Server 2005
SELECT SERVERPROPERTY('productversion') as Version,
SERVERPROPERTY ('productlevel') AS ServicePack,
SERVERPROPERTY ('edition') as Edition
GO
The results are:• The product version (for example, "9.00.1399.06").
• The product level (for example, "RTM").
• The edition (for example, "Enterprise Edition").
GO
SELECT @@VERSION
GO
USE master
GO
XP_MSVER
---Another way knowing service pack is by build number:
Microsoft SQL Server 2005 - 9.00.3042.00
Here '3042' is bulid number.And this is having SP2.
Another example is
Microsoft SQL Server 2005 - 9.00.3215.00
Here build number is '3215'.This is greater than 3042 build number so this is service pack 2.
For Build details we can go see :http://support.microsoft.com/default.aspx?scid=kb;en-q321185
SELECT SERVERPROPERTY('productversion') as Version,
SERVERPROPERTY ('productlevel') AS ServicePack,
SERVERPROPERTY ('edition') as Edition
GO
The results are:• The product version (for example, "9.00.1399.06").
• The product level (for example, "RTM").
• The edition (for example, "Enterprise Edition").
GO
SELECT @@VERSION
GO
USE master
GO
XP_MSVER
---Another way knowing service pack is by build number:
Microsoft SQL Server 2005 - 9.00.3042.00
Here '3042' is bulid number.And this is having SP2.
Another example is
Microsoft SQL Server 2005 - 9.00.3215.00
Here build number is '3215'.This is greater than 3042 build number so this is service pack 2.
For Build details we can go see :http://support.microsoft.com/default.aspx?scid=kb;en-q321185
Comments