Sometimes you may want to check whether a particular file is available while working with the file system in T-SQL. You can check this by using "xp_fileexist ", Sql Server Undocumented system stored procedure.
--//////////////////////////////////
declare @myfile int
exec master..xp_fileexist 'c:\screen.jpg' , @myfile out
select @myfile as FileStatus
--//////////////////////////////////
If "FileStatus" is "1", the file is available for use.