September 18, 2002 at 7:09 pm
I built a View 'Client_view1' with three base tables and created a unique clustered index on the view.
Now I am trying to create a trigger on this view and I get the error:
Server: Msg 208, Level 16, State 4, Procedure tiu_client, Line 1
Invalid object name 'Client_view1'.
I should be able to create triggers on Indexed Views? are there restrictions that I need to know about.
Thanks for your help.
September 18, 2002 at 7:14 pm
Is it true that you can only create Instead Of Triggers on Indexed Views?
September 18, 2002 at 8:21 pm
That's correct. Typically used to make a view updatable that otherwise would not be.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply