title: Run .exe file from SQL Query
body: <p>i am trying to open a .exe file from within an sql query or Job.</p>
  
  <p>im using xp_cmdshell , it is enabled on the server</p>
  
  <p>the .exe runs properly when i double click on it from my windows Explorer</p>
  
  <p>but when i try to open it using xp_cmdshell it returns to me 1 row affected
  and the row is null.</p>
  
  <p>the .exe file is supposed to delete all the content from a certain table.
  when i run the file from the windows explorer, the .exe deletes all the content of the above mentioned table, whereas when i try using xp_cmdshell the content of the table remain intact, which means the .exe file is not opened. </p>
  
  <p>any ideas?? this is the code i'm using</p>
  
  <p>exec master..xp_cmdshell  'C:\inetpub\wwwroot\Digital_Library_Shamaa\ShamaaConsoleIndexer\Publish\setup.exe'</p>
  
  <p>i have added the permission Everyone to the folder containing the above .exe file and all its sub folders!</p>