Verificar service Packs aplicados SQL Server

Dica de hoje é como verificar as atualizações aplicadas no seu SQL Server:

SELECT SERVERPROPERTY('MachineName') AS [MachineName], 
SERVERPROPERTY('ServerName') AS [ServerName], 
@@VERSION,
--SERVERPROPERTY('InstanceName') AS [Instance],
--SERVERPROPERTY('IsClustered') AS [IsClustered],
--SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [ComputerNamePhysicalNetBIOS],
SERVERPROPERTY('Edition') AS [Edition],
SERVERPROPERTY('ProductLevel') AS [ProductLevel],                                                       -- What servicing branch (RTM/SP/CU)
SERVERPROPERTY('ProductUpdateLevel') AS [ProductUpdateLevel],         -- Within a servicing branch, what CU# is applied
SERVERPROPERTY('ProductVersion') AS [ProductVersion],
--SERVERPROPERTY('ProductMajorVersion') AS [ProductMajorVersion],
--SERVERPROPERTY('ProductMinorVersion') AS [ProductMinorVersion],
--SERVERPROPERTY('ProductBuild') AS [ProductBuild],
--SERVERPROPERTY('ProductBuildType') AS [ProductBuildType],                    -- Is this a GDR or OD hotfix (NULL if on a CU build)
SERVERPROPERTY('ProductUpdateReference') AS [ProductUpdateReference], -- KB article number that is applicable for this build
CONVERT (varchar(256), SERVERPROPERTY('collation'))  collation
--SERVERPROPERTY('ProcessID') AS [ProcessID],
--SERVERPROPERTY('Collation') AS [Collation],
--SERVERPROPERTY('IsFullTextInstalled') AS [IsFullTextInstalled],
--SERVERPROPERTY('IsIntegratedSecurityOnly') AS [IsIntegratedSecurityOnly],
--SERVERPROPERTY('FilestreamConfiguredLevel') AS [FilestreamConfiguredLevel],
--SERVERPROPERTY('IsHadrEnabled') AS [IsHadrEnabled],
--SERVERPROPERTY('HadrManagerStatus') AS [HadrManagerStatus],
--SERVERPROPERTY('IsXTPSupported') AS [IsXTPSupported],
--SERVERPROPERTY('BuildClrVersion') AS [Build CLR Version];
SQL

Leave a Reply

Your email address will not be published. Required fields are marked *

search previous next tag category expand menu location phone mail time cart zoom edit close