Welcome to Sign in | Help

Re: cum creez un folder in T-SQL (SQLServer 2000)

  •  06-21-2007, 2:17 PM

    Re: cum creez un folder in T-SQL (SQLServer 2000)

    totul functioneaza super ok.....face si maparea respectivului folder (net use) dar cand incearca sa execute

    SET @tmpSQL='COPY x:\' + ' ' + '"' + @PathToMove + @PackFileName -- + '"' -- + @ParentBackupPath + '\' + @PackFileName
     EXEC @tmpServer @tmpSQL

    primesc eroarea:

    x:\*
    The system cannot find the file specified.
            0 file(s) copied.

    nu inteleg cum trebuie sa execute acest COPY.....syntaxa

    el formeaza acel @tmpSQL astfel:

    'COPY x:\ "D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\TEST_20070621_141258.RAR"'

    care vad ca nici din comand prompt nu functioneaza?!?!!.....cum ar trebui sa creeze acest COPY?

    alex.

     

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems