Credits:
Author: ChillyDBA
Date: 5 Jul 2012
Description
Utilizes the extended procedure xp_fileexists to determine whether a file exists or not using TSQL
This XP produces a single row result set with 3 columns, only one of which applies in this case. Unfortunately, the only way I can see of consuming this result set at the moment is by loading into a temp table - a crude but effective method.
Code
SET NOCOUNT ON
|