Microsoft SQL Server 2005 Best Practices

How to determine the domain name for the server?

Execute the following T-SQL script in Query Editor to find out the network domain name the server is operating on. The script calls an extended stored procedure for Windows 2003 server.

exec master.dbo.xp_regread 'HKEY_LOCAL_MACHINE',

'SOFTWARE\Microsoft\Windows NT\CurrentVersion\Winlogon', 'CachePrimaryDomain'

GO

------------

 

The Best SQL Server 2005 Training in the World
 
 
SQLUSA.com Home Page