create table #t (m ntext)
insert #t(m)
exec master..xp_cmdshell 'osql -L'
select case ltrim(cast(m as varchar(100)))
when '(local)' then cast(serverproperty('MachineName') as varchar(100))
else ltrim(cast(m as varchar(100))) end
from #t