Problems raised by calling external EXE execution in SQL Server _mssql

First, open xp_cmdshell

Open the perimeter application configurator->

The perimeter Application configurator for the feature->

Instance Name \database engine\xp_cmdshell->

Enable

Ii. Solutions

Use master Exec xp_cmdshell ' mkdir d:\csj '-Invoke the DOS command to create the folder (execution succeeded!). ）

Exec xp_cmdshell ' C:\calc.exe '--invoke exe (but EXE file, always show "executing query")

Third, if there is a problem

May appear as above "invoke EXE file (but execute EXE file, always show" executing query ")" problem, that is because, EXE program is not "automatic" and "automatic exit" These two points is very important. Refer to the following tips:

Note Some points:

1. Permissions

Xp_deletemail execution permissions are granted to members of the sysadmin fixed server role by default, but can be granted to other users

2. Mode of implementation

The xp_cmdshell is operated in a synchronized manner. Control is not returned until the command line interpreter command has finished executing.

3. cannot perform the user interaction command, for example, executes Notepad this needs the user to enter, closes and so on the operation procedure, will hang dies the program

4. If the program is to eject the user interface, the user interface will not pop

The above is a small set to introduce the external EXE in SQL Server to invoke the implementation of the program caused by the problem, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!