Sunday, February 19, 2012

Accessing the FileSystem

Is there a way to access the File System via T-SQL. There is a field in a
table of mine. In this table there is a filename to a file on my server. I
want to make sure that the filename actually points to a file on the server.
In other words I want to make sure the file exists!
Thanks in advancetry this
exec master..xp_fileexist 'C:\Program Files\Microsoft SQL
Server\MSSQL\readme.txt'
Denis the SQL Menace
http://sqlservercode.blogspot.com/|||Also try OLE Automation stored procedures.
Search for "OLE automation, FolderExists, copy, etc from stored
procedure" in this newsgroup. Date Posted: 4/26/2006 11:08:00 PM.
*** Sent via Developersdex http://www.examnotes.net ***

No comments:

Post a Comment