Welcome Guest, you are in: • Anmelden

CP Wiki

Navigation¶

Administration

Suche im wiki
»

Zurück

Domain per TSQL ermitteln

Modified on 10/02/2012 09:56 by CPARAS Categorized as Nicht kategorisiert

'''Domain per TSQL ermitteln'''

<code sql>
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 'Server Name: '+@@servername + ' Domain Name:'+convert(varchar(100),@Domain)
</code>

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.