thanks,maybe i should learn more about service broker could you tell me some link for more information to how it works.I only used it for notification from sql to application...
thanks for your replay.Maybe I became confused,I didnt now why trigger is on view?should not be on My Other Table that I want to log Information about it?In All Place...