September 24, 2007 at 1:54 pm
I have begun to use master..xp_fileexist, I have over 150,000+ documents in 15 different locations and have to audit an application to ensure that the docs it says exist are really there.
My question is: Is there a limit to the number of directories it will drill down to?
ex1: (This returns a 1)
master..xp_fileexist 'c:\autoexec.bat'
ex2: (This returns a 0)
master..xp_fileexist '\\eclinic.aldc.local\Photos\133752\472065.jpg'
I know the above document does exist in this directory.
Any thoughts outthere?
September 24, 2007 at 2:28 pm
Is the servername correct in your example using an UNC? I just tried it on one of my servers and it works fine going down several directories.
September 26, 2007 at 12:41 pm
Does the service account for SQL have access to the network share?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply