'xp_cmdshell returning null and not logging

So im trying to log a test message to a directory in sql but eveytime i run the query i get output:null and no logging whatsoever. Any help

Begin --To append
    SET @strCmdLogFailed= 'echo >> '+ @strErrorLogPath + 'My Item           Something           Date' --+ Convert(Varchar(5000), @strItemsNotRegisteredList)
    select @strCmdLogFailed
    Exec master..xp_cmdshell @strCmdLogFailed
End
sqlloggingcmd


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions