How can I find out which Service Pack is installed on my copy of SQL Server?
我如何知道在我的SQL Server副本上安装了哪些服务包?
2 个解决方案
#1
19
From TechNet: Determining which version and edition of SQL Server Database Engine is running
来自TechNet:确定SQL Server数据库引擎正在运行的版本和版本
-- SQL Server 2000/2005
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
-- SQL Server 6.5/7.0
SELECT @@VERSION
#2
5
Select @@Version
Ex: My machine has the following one installed.
我的机器安装了以下一种。
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Enterprise Edition on Windows NT 6.1 (Build 7601: Service Pack 1)
微软SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02版权(c)微软公司企业版Windows NT 6.1 (Build 7601: Service Pack 1)
#1
19
From TechNet: Determining which version and edition of SQL Server Database Engine is running
来自TechNet:确定SQL Server数据库引擎正在运行的版本和版本
-- SQL Server 2000/2005
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
-- SQL Server 6.5/7.0
SELECT @@VERSION
#2
5
Select @@Version
Ex: My machine has the following one installed.
我的机器安装了以下一种。
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Enterprise Edition on Windows NT 6.1 (Build 7601: Service Pack 1)
微软SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02版权(c)微软公司企业版Windows NT 6.1 (Build 7601: Service Pack 1)