The below script is very useful to find the domain details of SQL Instance installed
specially if you don't have access to RDP the server.
DECLARE @Domain VARCHAR(100) ,@key VARCHAR(100) SET @key = 'SYSTEM\ControlSet001\Services\Tcpip\Parameters\' EXEC master..xp_regread @rootkey = 'HKEY_LOCAL_MACHINE' ,@key = @key ,@value_name = 'Domain' ,@value = @Domain OUTPUT SELECT @@servername [SQL Instance Name] ,convert(VARCHAR(100), @Domain) AS [DomainName] ,'10.170.201.206' IPAddress
No comments:
Post a Comment