ok i see what you are trying to do;
in order for this to work, the acount that is running the services will need domain admin priviledges in order to browse to the default shares like \\machinename\c$
but it's still a variation of what i pisted, except using host_name(0 instead of the serverproperty:
declare @path varchar(255)
set @path = 'C:\Program Files\CScrew'
select '\\' + convert(varchar(255),host_name()) + '\' + REPLACE(@path,':\','$\')
the host_name() would resolve to whatever machine is connecting...hopefully from within the smae network/domain the server is on.
Lowell