Creating Triggers on a View?

[sheryl kemp]

Is it possible to create a trigger on a view? when I tried this, I get the
message that the view object doesn't exist.

[David Satz]

A view can be referenced only by an INSTEAD OF trigger.
--
HTH,
David Satz
Principal Web Engineer
Hyperion Solutions
{ SQL Server 2000 SP2/6.5 SP5a } { Cold Fusion 5 SP1 } { VSS }
(Please reply to group only - emails answered rarely)
-----------------------------------------------------------------
"sheryl kemp" <dianedinero@aol.com> wrote in message
news:3cb1cc77$1@10.1.10.29...
>
> Is it possible to create a trigger on a view? when I tried this, I get the
> message that the view object doesn't exist.