Tuesday, April 26, 2011

A File Exists from SQL Server Query?

Easy to do:

exec xp_fileexist 'c:\renepally.txt'

Results:
File Exists1
File is a Directory0
Parent Directory Exists1

No comments:

Post a Comment