One other way to get the machine name...

I use it to see which node has the load in clusters.

DECLARE @test-2 varchar(20)

EXEC master.dbo.xp_regread

'HKEY_LOCAL_MACHINE', 

'SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName',  

'ComputerName',

@test-2 OUTPUT

select...

Hoo-t, if it was me, I'd stop SQL's services, swap your current drive letter(s) for the SAN drive letter(s) and copy the data to the SAN drive that now has the same drive...

I assume you really are looking for a way to read a registry value with TSQL. There is an undocumented extended stored procedure that does that. (Undocumented means unsupported...)

EXECUTE xp_regread...

Have you installed the SQL Server 6.5 client?

I believe that is required for a 16 bit ODBC conncetion.