Set the permissions so that everyone only has SELECT permission for the view.
-Mike
>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