Do more with
DECLARE @nameVarchar VARCHAR(16)
DECLARE @bigVarchar as varchar(500)
IF serverproperty('IsClustered') = 1
BEGIN
EXEC master..xp_regread N'HKEY_LOCAL_MACHINE' , 'Cluster' , N'ClusterName', @nameVarchar OUT
PRINT 'Klustrad = ''Yes''' + ' Klustrets namn: ' + '''' + @nameVarchar + ''''
PRINT 'Servernamn: ' + '''' + Cast(serverproperty('MachineName') as varchar) + ''''
PRINT 'Instans: ' + '''' + Cast(serverproperty('InstanceName') as varchar) + ''''
-- Find IP THROUGH SQLCMD
SET @bigVarchar = 'PING ' + Cast(serverproperty('MachineName') as varchar) + ' -n 1'
INSERT INTO #TempIP (RegKey)
EXEC XP_CMDSHELL @bigVarchar
SELECT @bigVarchar = REGKEY
FROM #TempIP
WHERE REGKEY LIKE 'Pinging%'
SET @bigVarchar = RIGHT(@bigVarchar,LEN(@bigVarchar)-CHARINDEX('[',@bigVarchar))
SET @bigVarchar = LEFT(@bigVarchar,CHARINDEX(']',@bigVarchar) -1)
PRINT 'Klustrets IP: ' + '''' + @bigVarchar + ''''
EXEC master..xp_instance_regread 'HKEY_LOCAL_MACHINE',N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp\IPAll','TcpDynamicPorts', @nameVarchar OUT
PRINT 'TcpDynamicPorts: ' + '''' + @nameVarchar + ''''
END
ELSE
BEGIN
PRINT 'Klustrad = ''No'''
PRINT 'Servernamn: ' + '''' + Cast(serverproperty('MachineName') as varchar) + ''''
END
Premium Content
You need an Expert Office subscription to comment.Start Free Trial