• Thanks for replying Jeet,

     

    a) there's nothing in the event viewer

    b) It fails on the "EXEC @rc = sp_OAMethod @lFolder, 'Size', @lFolderSize OUT" line.

    c) The path is valid. It is checking (and copying/moving/deleting) thousands of folders and after a while there is this single error repeatedly (other OLE calls are still OK). (can't wait to user C# in SQL2005 )

    PS: It will also fail with a Permission Denied if there is a NTFS map in the hierarchy below the folder involved. This is an undocumented bug in the file scripting object.

    I'm trying to know what this undocumented 10077 error is so I can resolve it or work aroud it OR find another way to get the folder size

    regards,

    Eric