I have the following query:
exec xp_cmdshell 'copy f:\temp\Formatos\Base_PptoER.xls f:\temp\Varios\Base_PptoER.xls'
It shows me the following:
The process works correctly, the detail I have is that I need that when running this line of code it does not show me the result of the attached image, only that it does its process and does not show me that notification.
According to the documentation so that this extended procedure of the system does not return results you have the option
NO_OUTPUT
This way it would look like this:
According to the official documentation , you can use
no_output
so that it does not return anything to the client.If you don't want to see the output as a result, the optimal thing is to insert this data into a table, which could eventually serve as an audit: