Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to create an executable that would be triggered by Sql Server when a row is inserted into a certain table. Does Sql Server offer any sort of hooks that would do something like that? If so, where would I find documentation or a tutorial?

share|improve this question
up vote 2 down vote accepted

Knowing which version of SQL server would be helpful.

You'll want to have a look at triggers. In this particular instance, you'll use a trigger to call a stored procedure, which will then call your executable.

Keep in mind that it's pretty easy to get sideways with triggers in terms of both security and that certain triggers can fire when ANY valid event occurs (and not necessarily row changes occur).

share|improve this answer
Yeah, as for version, I'm not sure what's installed as I don't maintain the DB. But I'll look into this solution. Thanks! – Mike Caron Nov 16 '10 at 17:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.