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 2000 Forums
 SQL Server Development (2000)
 How start an application with a trigger???

Author  Topic 

pldelosrios
Starting Member

4 Posts

Posted - 2004-04-20 : 12:54:17
Hi!

I would start a little application when a trigger fires

Is it possible??

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-04-20 : 12:57:10
I'm sure you could do it with xp_cmdshell, but that would be highly not recommended. Why do you want to do this? What is the business reason?

Keep in mind:

"xp_cmdshell operates synchronously. Control is not returned until the command shell command completes."

Tara
Go to Top of Page

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-04-20 : 12:58:23
It is possible to perform using xp_cmdshell. Though, performing this kind of activity can quickly become a bad design choice...

Can you elaborate on your intent. What type of application are you considering launching from a trigger?
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-04-20 : 13:05:25
quote:
Originally posted by tduggan

I'm sure you could do it with xp_cmdshell, but that would be highly not recommended. Why do you want to do this? What is the business reason?

Keep in mind:

"xp_cmdshell operates synchronously. Control is not returned until the command shell command completes."

Tara



AND independant....

I can hear someone going...damn, that's a lot of spids......



Brett

8-)
Go to Top of Page
   

- Advertisement -