Was xp_MoveFile a standard SQL Server v7 extended stored procedure?
I am doing the initial research at moving legacy SQL Server v7
databases to SQL 2000 (hold all flames, since the entire server is
migrating, I lobbied for SQL 2005 at minimum).
There were two common errors. The first was a missing linked server
referenced by 4 SP's ... no big deal. The second error was a much more
abundant as far as counts:
"Cannot add rows to sysdepends for the current stored procedure
because it depends on the missing object 'master..xp_movefile'. The
stored procedure will still be created."
I can see the SP on the v7 Master DB. It points to a DLL that does
reside on the old v7 server. When I search Mircosoft's MSDN web site,
I don't get any results for either the SP or the DLL it referances. From what I
can tell, the SP takes as parameters a file path to an existing file
and a string:
IF (@result = -1)
SET @ErrorText = 'Unable to determine file size of ''' +
@FilePath + '''.'
EXEC AddError 0, @ErrorText
EXEC master..xp_movefile @FilePath, 'Bad'