Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 7 down vote favorite

I was wondering if it is possible to enable a trigger just for my current application and not for any sql executed against the table.

The situation:

There are two applications working on the same database. App1 and App2.

I have a trigger on 'MyTable' which should only be fired when App1 is executing a query, but not when App2 is doing so.

share|improve this question
Well its logical . isn't it ? where would you have the app name ? If you do have access to it in the trigger ( inserted ) then its easy . – Super Peon Jun 18 at 14:58
1  
Patric, as an alternative to using APP_NAME(), you can also use SET CONTEXT_INFO. SET CONTEXT_INFO is commonly used to send info to triggers like this. – Nick Chammas Jun 25 at 9:08
add comment (requires an account with 50 reputation)

1 Answer

up vote 9 down vote accepted

While not a good design, it is doable. You'll need to put logic in the trigger so it causes the code to only be executed when the correct application is connected. 

Create trigger... 
As
    If app_name() = 'something' 
    begin 
        put code here 
    end
share|improve this answer
7  
It may not be a concern in this specific case, but other potential readers should note that app_name() is very easy to spoof via connection string properties. – Aaron Bertrand♦ Jun 18 at 13:21
3  
Yup, very easy to spoof. Don't do this for security purposes, but for working around minor software deficiencies, or other convenient tricks, you're probably okay. We've got a few that do this. – db2 Jun 18 at 15:25
Very true, this would be VERY easy to get around. But assuming that there's no naught intentions of the application users (I can't believe I just put that) it'll work. Not the best idea, but it'll do the job. Jon, thanks for formatting. Wasn't going to try doing that on my phone. – mrdenny♦ Jun 19 at 0:29
add comment (requires an account with 50 reputation)

Your Answer

 
discard

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.