<div>
two possibilities:<br />
<br />
1) If you try to execute a program that requires user input, the xp_cmdshell process will hang. Some command line utilities are interactive and you need to set some switches so that it runs in quiet mode, maybe this utility works that way too.<br />
<br />
2) The Account SQL Server is running should have the necessary privileges to run the program. When you run from command prompt, it runs under your account while in xp_cmdshell it runs under sql service account. 
</div>


two possibilities:

1) If you try to execute a program that requires user input, the xp_cmdshell process will hang. Some command line utilities are interactive and you need to set some switches so that it runs in quiet mode, maybe this utility works that way too.

2) The Account SQL Server is running should have the necessary privileges to run the program. When you run from command prompt, it runs under your account while in xp_cmdshell it runs under sql service account.

<div>
dba2dba --<br />
<br />
Thanks for replying me.<br />
<br />
My XP_CMDSHELL only required path for .EXE.<br />
<br />
I am just trying to call .EXE file from XP_CMDSHELL - it does not need any other parameter or user interaction.<br />
<br />
pls correct me if i am wrong 
</div>


dba2dba --

Thanks for replying me.

My XP_CMDSHELL only required path for .EXE.

I am just trying to call .EXE file from XP_CMDSHELL - it does not need any other parameter or user interaction.

pls correct me if i am wrong

<div>
<div class="content wysiwyg-content">
Hi Friends,<br />
<br />
I have One Winows Application.<br />
<br />
When I run Windows Application EXE, it is running well and finishing up in 1 Min. duration.<br />
<br />
When I Exeucte this Exe from XP_CMDSHELL , it is keep running on SQL Server.<br />
<br />
Execute MAster..XP_CMDSHELL 'C:\Test.Exe'<br />
<br />
Can anyone guide me, why it is keep running through XP_CMDSHELL ?<br />
<br />
Thanks.
</div>
</div>


Hi Friends,

I have One Winows Application.

When I run Windows Application EXE, it is running well and finishing up in 1 Min. duration.

When I Exeucte this Exe from XP_CMDSHELL , it is keep running on SQL Server.

Execute MAster..XP_CMDSHELL 'C:\Test.Exe'

Can anyone guide me, why it is keep running through XP_CMDSHELL ?

Thanks.

XP_CMDSHELL store procedure keep running on SQL Server 2005 - What could be the problem ?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications