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 2005 Forums
 Transact-SQL (2005)
 How to overcome xp_cmdshell limitations?

Author  Topic 

Wodzu
Yak Posting Veteran

58 Posts

Posted - 2008-03-06 : 09:35:47
Hi.

I really need to call an external application with GUI but xp_cmdshell does not allow it. Is there any way to do this?

Thanks in advance for replays.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-03-06 : 13:37:00
You can't do it with xp_cmdshell, so you'll need to handle this in your application.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

Wodzu
Yak Posting Veteran

58 Posts

Posted - 2008-03-07 : 03:53:25
Maybe I said it not to clearly. I know that I can't do it by xp_cmdshell.

I am asking: what can I do to run via T-SQL externall application with graphics user interface?

I've tried to run an exe application without GUI which fires up another application (asynchronously) with GUI but still it didnt help :|
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-03-07 : 11:54:44
You can't do it via T-SQL as the process won't run in the same user session.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -