I've checked BOL and I don't see what I'm looking for. I know that Oracle has a "WITH READ ONLY" option when creating a view. I don't see this option in SQL2000. Do I need to add an INSTEADOF trigger to accomplish this? In short, I don't want users of the view to be able to update the data.
Thanks ST