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
ASKER
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
TRUSTED BY