How to make trigger code execute only for a specific application?
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