create table #files ( FileName varchar( 255 ) NULL )
declare @cmdstr varchar( 255 ) , @exists bit
select @cmdstr = 'dir/b ' + 'C:\winnt\explorer.exe1' , @exists = 0
insert into #files exec master..xp_cmdshell @cmdstr
if exists( select * from #files )
        select @exists = 1
select @exists as FileExists
drop table #files
go

-- Using undocumented SQL70 SP:
declare @exists int
exec master..xp_fileexist 'c:\winnt\explorer.exe1' , @exists out
select @exists as FileExists

This page was last updated on May 01, 2006 04:28 PM.