Hello,

I have a problem with a view in SQL 2000. I want this view to be read only, but I can't find an easy way to accomplice that.
My first idea was to create a trigger on the view which raises an error, but I can't create a trigger on the view.
My next attempt was an instead of trigger (on insert, upadte and delete). This works fine when I insert, update or delete a record in code, but when I open the view in the MMC I can add a record without any problem.
So my questions are:

* Has anyone an idea how to get a readonly view?
* Why can't I heve triggers on views (it should be possible according to the BOL)?
* Why are instead of triggers not fired by the MMC?

TIA,

Martin