I'm trying to create a file from a query executing xp_cmdshell with BCP command, but it does not finish. No error messages are shown. It keeps executing query forever. I have to end the proccess by windows task manager.
check MSSQLSERVER permissions on folders -> It is ok;
run the same BCP command on CMD -> worked well;
run a mkdir on xp_cmdshell (no BCP commands) in SQL SERVER -> worked well.
Running on SQL SERVER 2012.