Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: getting error "The system cannot find the path specified." using xp_cmdshell

    analogue xp_cmdshell

    -----------------------

    MSSQL2000 :

    nothing

    MSSQL2005 :

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'Ole Automation Procedures', 1;

    GO

    RECONFIGURE;

    GO

    -----------------------

    declare @iShl int, @iStm int, @iStdOut int, @hr int, @EndOfStream int,

    @strText nvarchar(4000), @cmd nvarchar(4000)

    set @cmd = 'Exec("cmd /c...

Viewing post 1 (of 1 total)