That got me to the right spot with that link

Declare @datadir nvarchar(4000)

,@logdir nvarchar(4000)

EXEC master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE'

, N'Software\Microsoft\MSSQLServer\MSSQLServer'

, N'DefaultData'

, @datadir output;

IF @datadir IS NULL

BEGIN

EXEC master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE'

, N'Software\Microsoft\MSSQLServer\Setup'

, N'SQLDataRoot'

, @datadir output;

END

EXEC master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE'

, N'Software\Microsoft\MSSQLServer\MSSQLServer'

, N'DefaultLog'

, @logdir output;

SELECT @datadir as Data_directory, ISNULL(@logdir,@datadir) as Log_directory

That being said it is magic. I am not sure how it is coming back with the right answer. I searched the registry and did a search for the result and both came back empty. I am going to give this a try and see if it gets past testing. Thanks