Calling external EXE execution program in SQL Server

Calling external EXE execution program in SQL Server

EXE SQL Server XP database DOS server

First, open the xp_cmdshell

Open the surface area configurator,

Features of the perimeter application configurator,

Instance Name \database engine\xp_cmdshell->

Enable

Second, the solution

[SQL] View plain copy

Use master Exec xp_cmdshell ' mkdir d:\csj '--Call DOS command to create a folder, (Execution succeeded!) ）

[SQL] View plain copy

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

Third, if there is a problem

It may appear as above "calling EXE file (but executing EXE file, always show" executing query ")" Problem, because EXE program is not "automatic execution" and "Auto Exit" is important. Refer to the following tips:

Note the points:

1. Permissions

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

2. Execution mode

The xp_cmdshell operates synchronously. Control is not returned until the command-line interpreter command finishes executing.

3. Unable to perform user interaction commands, such as the implementation of Notepad such as user input, close the operation of the program, will hang dead program

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

Calling external EXE execution program in SQL Server