Asterisk (*) may not be used in an indexed view.
Because an indexed view is stored on disk, the view definition must explicitly refer to the columns to be included in the view. Replace the asterisk with the columns you want to include in the view.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback