What should you do?
A. Create the view by using an account in the sysadmin role.
B. Add a DDL trigger to the project assignment table to re-create the view after any schema change.
C. Create the view in a new schema.
D. Add a DDL trigger to the view to block any changes.
Answer:B
What should you do?
A. Create the view by using an account in the sysadmin role. B. Add a DDL trigger to the project assignment table to re-create the view after any schema change. C. Create the view in a new schema. D. Add a DDL trigger to the view to block any changes.