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 intexec master..xp_fileexist 'c:screen.jpg' , @myfile outselect @myfile as FileStatus--//////////////////////////////////
If “FileStatus” is “1”, the file is available for use.