This works for me, but xp_cmdshell is needed:

EXEC xp_cmdshell 'powershell -NoProfile -Command "(Get-Item $env:TEMP).FullName"';