I'm writing a proc to do tlog backups. I want to validate the path before
attempting to issue the backup command but I don't see any documented file
handling funtions in T-SQL. What's the best approach for this?

Thanks,

Bob Castleman
DBA Poseur

Implement a DTS package that first uses the FSO.FileExists function via a
ActiveX Script task to verify the folder. If the task returns success, then
use a Execute SQL task to call your SP.

Function Main()

Main = DTSTaskExecResult_Failure

sCopyFrom = "c:\temp\xxx.tmp"

sCopyTo = "c:\temp\xxx.dat"

set FSO = CreateObject("Scripting.FileSystemObject")

if not FSO.FileExists( sCopyFrom ) then
  exit function
end if

if FSO.FileExists( sCopyTo ) then
  FSO.DeleteFile sCopyTo
end if

FSO.CopyFile sCopyFrom, sCopyTo

set FSO = nothing

Main = DTSTaskExecResult_Success

End Function

Show quoteHide quote

Return always 0.
Hoping not everyone is gone the Friday before Memorial Day!
Implementing natural keys
Multiple FK or "TableName" column?
Mode and Median functions in SQL 2000
Copy Database
Drop all indexes
partitioned view goofiness
Newbie: UPDATE a Table
how to aduit database access?