Hi all, Does anyone knows

[hkung]

Hi all,

Does anyone knows if there's a system store procedure in SQL 2000 which is similar to sp_MSexists_file in SQL 7? I need something to check for the existence of certain file and i guess this is the fastest way to achive my objective . I've tried executing sp_MSexists_file in SQL 7 and it's working fine. However, it doesn't work in SQL 2000 as i can't find this procedure in SQL 2000 master db. Anyone has any ideas how should i go abt it?
Your help will be greatly appreciated. Thanks in advance.

 

[Rishi146]

hi a couple of ideas check out

http://groups.google.com/groups?q=sp_MSexists_file&hl=en&selm=dUHq7.504$tR2.18122@localhost&rnum=1

or
in SQL 2000 TRANSACT HELP (transact help type --- xp_cmdshell

or use Dts package more hectic for what i think you are doin but will work in that create an active x script in the script place this code

--------
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************

Function Main()

Dim fso
Dim strSourcePath
Dim strDestPath
Dim strNewFileName
Dim workstr


strSourcePath = "\\Lndc1\Global\London Data\LNCommon\Iss Apps\MIS Download\Newnames\email.txt"

Set fso = CreateObject("Scripting.FileSystemObject&quot

If fso.FileExists(strSourcePath) Then
' fso.DeleteFile strSourcePath, False
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_failure
End If
End Function

Rishi(MCSD,MCP,MCDBA)





---------

 

[tlbroadbent]

Use xp_fileexist in SQL 2000. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.