就可以用xp_cmdshell判断文件是否存在的比如
DECLARE @myresult int
EXEC @myresult = xp_cmdshell "dir c:\test.txt"
IF(@myresult = 0)
PRINT "文件存在"
ELSE
PRINT "文件不存在"
DECLARE @myresult int
EXEC @myresult = xp_cmdshell "dir c:\test.txt"
IF(@myresult = 0)
PRINT "文件存在"
ELSE
PRINT "文件不存在"
wistaria:非常感谢, 问题全解决后一定给分.