--SQL 2000/2005 Version

set nocount on
go
	DECLARE @SqlPath Nvarchar(255)
	DECLARE @instance_name Nvarchar(30)
	DECLARE @reg_key Nvarchar(500)	
	Declare @value_name Nvarchar(20)
	Declare @LoginMode_Value int
	Declare @LoginMode Nvarchar(15)

if left(CAST(SERVERPROPERTY('ProductVersion')AS sysname),1) = '9'
BEGIN
	select 	@instance_name = CAST(SERVERPROPERTY('instancename')AS sysname)

	if @instance_name is NULL
	BEGIN
		set @reg_key = 'SOFTWARE\Microsoft\MSSQLServer\MSSQlServer\SuperSocketNetLib\Tcp'	
	END
	ELSE BEGIN
		set @reg_key = 'SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL'
	END

	EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE', 
	@key=@reg_key, @value_name=@instance_name,
	@value=@SqlPath output
	
	if @instance_name is NULL
	BEGIN
		set @reg_key = 'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\'	
	END
	ELSE BEGIN
		set @reg_key = 'SOFTWARE\Microsoft\Microsoft SQL Server\' + @sqlpath + '\MSSQLServer\'
	END		

	EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE', 
	@key=@reg_key, @value_name='LoginMode',
	@value=@LoginMode_Value output
	
	if @LoginMode_Value = 1
		set @LoginMode = 'Windows'
	if @LoginMode_Value = 2
		set @LoginMode = 'Mixed'		

	select CAST(SERVERPROPERTY('ServerName')AS sysname) as ServerName, @LoginMode as AuthenticationMode
	
END

if left(CAST(SERVERPROPERTY('ProductVersion')AS sysname),1) = '8'
BEGIN
select 	@instance_name = CAST(SERVERPROPERTY('instancename')AS sysname)

	if @instance_name is NULL
	BEGIN
		set @reg_key = 'Software\Microsoft\MSSQLServer\MSSQLServer'	
	END
	ELSE BEGIN
		set @reg_key = 'SOFTWARE\Microsoft\Microsoft SQL Server\' + @instance_name + '\MSSQLServer'
	END

	EXEC master..xp_regread @rootkey='HKEY_LOCAL_MACHINE', 
	@key=@reg_key, @value_name=LoginMode,
	@value=@LoginMode_Value output	
	
	
	if @LoginMode_Value = 1
		set @LoginMode = 'Windows'
	if @LoginMode_Value = 2
		set @LoginMode = 'Mixed'		

	select CAST(SERVERPROPERTY('ServerName')AS sysname) as ServerName, @LoginMode as AuthenticationMode
END