Welcome to Sign in | Help

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

  •  06-21-2007, 4:06 PM

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

    merge :)

    SET @tmpServer='master..xp_cmdshell'

     SET @tmpSQL='NET USE X: \\' + @SysServerName + '\' + @ParentBackupPath
     EXEC @tmpServer @tmpSQL

     SET @tmpSQL='COPY ' +  @LocalBackUPPath + '\' + @PackFileName + ' X:\'
     EXEC @tmpServer @tmpSQL
     SET @tmpSQL='DEL ' +  @LocalBackUPPath + '\' + @PackFileName
     EXEC @tmpServer @tmpSQL 
     EXEC @tmpServer 'NET USE X: /DELETE'

    problema era una minora ca de obicei :)

    era "copy FisierDeCopiat CaleaUndeSeDOresteAfiCopiat"....nu invers :)

    alex

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