Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blackX
Posting Yak Master
102 Posts |
 Posted - 2009-10-13 : 14:02:17
|
| I have a trigger that updates the record everytime an update is performed. I also have a view that is based on the same table as the trigger. My problem is when a record is updated via the view then the trigger is not called on the underlying table. Is there anything I can do to force the trigger to be called when the record is updated inside of the view?Thanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-10-13 : 14:10:31
|
| I can not duplicate that problem. generate and post the sql scripts for your CREATE TABLE, CREATE VIEW, CREATE TRIGGER for your objects.Be One with the OptimizerTG |
 |
|
|
blackX
Posting Yak Master
102 Posts |
Posted - 2009-10-13 : 15:39:26
|
| After reading your response I dug a little deeper. The trigger has a condition if update(contactstatus) and update(contactdate)...the view does not contain the contactdate so therefore the record would not be effected by the trigger thanks |
|
|
|
|
|
|
Trigger question