General information
Forum:
Microsoft SQL Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only