Hi,Access denied using SQL server "master.sys.xp_cdmshell"

Question

Hi, I was trying to create a TXT file using:   exec master.sys.xp_cdmshell 'echo HOLA > c:\hola.txt'   but i got an "Access denied using SQL server "master.sys.xp_cdmshell"   Instead of talk to a Operating System Administrador for give permission needed, I Rather use another method to create the TXT file   HELP ME   Thanks..

Tejas Trivedi · Accepted Answer

Hi Ramon,   it is for sure there is permission issue for the user running sql server command. There are many other ways to write text file in sql server like osql/sql, bcp, COM calls.   Please refere below links to explore some of them.   https://www.red-gate.com/simple-talk/sql/t-sql-programming/reading-and-writing-files-in-sql-server-using-t-sql/   https://stackoverflow.com/questions/8132663/creating-a-text-file-on-local-machine-using-sql-server-2008   Most of them are writing the file to server by default.     Please don't forget to mark this as an answer if it helps.