in

RichmondSQL

Richmond SQL Server Users Group

SQL Server v7 Stored Procedure Question

Last post 09-19-2008 9:44 AM by bee_kea. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 09-19-2008 9:44 AM

    SQL Server v7 Stored Procedure Question

    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)
       BEGIN
          SET @ErrorText = 'Unable to determine file size of ''' +
    @FilePath + '''.'
          EXEC AddError 0, @ErrorText
          EXEC  master..xp_movefile @FilePath, 'Bad'
       END
    ELSE
       BEGIN
       :
       :

    Any idea's?

    B

    Filed under:
Page 1 of 1 (1 items)
Join Our Mailing List!

We've disabled the signup functions on this website. If you want to receive email updates about meetings and events, you need to join our new Mailing List!

Join Today!
©2006-2011 Richmond SQL Server Users Group; ©2008-©2011 Richmond User Groups Corporation
Powered by Community Server (Non-Commercial Edition), by Telligent Systems