MSSQL ADMINISTRATION IN HINDI | MSSQL DBA CLASS IN HINDI | LEARN MSSQL IN HINDI IF NOT EXISTS (SELECT * WHERE CONVERT(varchar(128), SERVERPROPERTY(‘ProductVersion’)) LIKE ‘13%’)
BEGIN
DECLARE @ProductVersion varchar(128) = CONVERT(varchar(128), SERVERPROPERTY(‘ProductVersion’));
RAISERROR (‘Script does not match the ProductVersion [%s]
of this instance. Many of these queries may
not work on this version.’ , 18 , 16 , @ProductVersion);
END
ELSE
PRINT N’You have the correct major version of SQL Server for this diagnostic information script’;

— This query might take a few seconds if you have not recycled your error log recently
EXEC sys.xp_readerrorlog 0, 1, N’detected’, N’socket’;
— Get selected server properties (Query 3) (Server Properties)

SELECT SERVERPROPERTY(‘MachineName’) AS [MachineName],
SERVERPROPERTY(‘ServerName’) AS [ServerName],
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
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(‘InstanceDefaultDataPath’) AS [InstanceDefaultDataPath],
SERVERPROPERTY(‘InstanceDefaultLogPath’) AS [InstanceDefaultLogPath],
SERVERPROPERTY(‘IsPolybaseInstalled’) AS [IsPolybaseInstalled], — New for SQL Server 2016
SERVERPROPERTY(‘IsAdvancedAnalyticsInstalled’) AS [IsRServicesInstalled], — New for SQL Server 2016
SERVERPROPERTY(‘BuildClrVersion’) AS [Build CLR Version]; MSSQL SERVER ADMINISTRATION IN HINDI