Assuming all the necessary prerequisite requirements are met, Sql Server will make partitioned views writable. How can I identify what views are in this state? A followup question would be- does the engine make this determination at the time the view is created and store it as an attribute of the view or is it determined dynamically?

If the latter, I would assume there is no way to verify correct operation without writing to the view. Is this correct?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.