[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 147
  • Last Modified:

Can i use a trigger in SQL 2005 to hit a url or update a file

Can i use a trigger in SQL 2005 to hit a url, call a webservice or update a file?

And if not can i get a trigger to run an exe located?
0
paulCardiff
Asked:
paulCardiff
  • 4
  • 4
1 Solution
 
Ashish PatelCommented:
for running an exe just you have say the below line

exec master.dbo.sp_cmdshell 'YourApplication.exe'
0
 
paulCardiffAuthor Commented:
Thanks for that though i must admit the exe was my plan b - as i was going to use the exe to hit a url/webservice.

But in the interests of avoiding that extra layer of maintenance is there anything simular for calling a url / webservice?
0
 
Ashish PatelCommented:
No there isnt any way of calling url or webservice.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
paulCardiffAuthor Commented:
what about using a sql agent or alt sql?
0
 
paulCardiffAuthor Commented:
* sql? = sqlclr
0
 
Ashish PatelCommented:
I guess, not with sql agent too, and i am not sure about others.
0
 
Ashish PatelCommented:
actually the 2nd option of using your application exe is better way i think.
0
 
paulCardiffAuthor Commented:
Ok thanks
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now