CANNOT RUN EXECUTABLES - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

CANNOT RUN EXECUTABLES

Author

Topic

SREE LEKSHMI.M
Starting Member

3 Posts

Posted - 2012-01-20 : 23:40:54

I was not able to run an exe.What i did is I created a storedprocedure as shown
ALTER Procedure [dbo].[pdfConverter]
As
begin
EXEC master..xp_cmdshell'C:\WINDOWS\system32\notepad.exe'
end

Thn I executed the stored procedure
Exec pdfConverter

But the querry is executing for long time and no result and when i checked the taskmanager that exe is not running.

Please help it's very urgent...

biswajitdas
Starting Member

44 Posts

Posted - 2012-01-22 : 18:23:44

1) can you check from the sp_configure is that xp_cmdshell is enabled or not to run

Sr Sql server DBA/Artitech

SREE LEKSHMI.M
Starting Member

3 Posts

Posted - 2012-01-22 : 23:38:16

HOW CAN I CHECK THAT.Before running that exec i have configured the xp_cmdshell as shown
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2012-01-23 : 10:46:07

You can check xp_cmdshell setting in Surface Area Configuration for Features (2005). In 2008 may be SQL Server Configuration Manager.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources