Sometimes you need to check to see if a file exists before you put the path in your database. Per local rumor this is an undocumented sproc in SQL Server. Love it, use it. 1 means yeah 0 means no. Try it out!
xp_fileexist ‘C:\test.txt’ from SSMS.
Sometimes you need to check to see if a file exists before you put the path in your database. Per local rumor this is an undocumented sproc in SQL Server. Love it, use it. 1 means yeah 0 means no. Try it out!
xp_fileexist ‘C:\test.txt’ from SSMS.
No Comments, Comment or Ping
Reply to “xp_fileexist”