How to open external exe file from SQL Query.
I activate
USE master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE
GO
then pass query but not run below is query
DECLARE @command varchar(8000)
SET @command = 'C:\MyProgram.exe'
EXEC master..xp_cmdshell @command
When i pass the query is not showing executing but not open exe file.
Thanks
Basit.
USE master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE
GO
then pass query but not run below is query
DECLARE @command varchar(8000)
SET @command = 'C:\MyProgram.exe'
EXEC master..xp_cmdshell @command
When i pass the query is not showing executing but not open exe file.
Thanks
Basit.
Basit KhanPosted May 6, 2016, 12:25 PM
Shakti Singh DulawatPosted May 6, 2016, 11:50 AM
Basit KhanPosted May 6, 2016, 11:37 AM
Shakti Singh DulawatPosted May 6, 2016, 4:19 AM
set the executable path