How do I check if a SQL Server 2005 installation has been Service Packed?
June 14, 2008
You can check whether a SQL Server 2005 installation has been service packed by running the following SQL code:
SELECT SERVERPROPERTY (‘productlevel’)
If SQL Server has been service packed, it will return with the Service Pack version installed, eg. “SP2″. If it has not been service packed, it will return with the result “RTM”.
Entry Filed under: Uncategorized. Tags: 2005, productlevel, server, SERVERPROPERTY, service pack, SP, SP1, SP2, sql, version.
Trackback this post | Subscribe to the comments via RSS Feed