Check for OS File Existence from T-SQL

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: