Msit Reviewer

Lab 1: Users report that insert statements against the view named Production.vExpensiveExpiredProduct do not succeed. You confirm that the insert statements that are being used are valid. You need to ensure that insert statements can complete successfully. Use SSMS - Open up SSMS. - Goto Server \Databases \Adventureworks\ Views\ Production.vExpensiveExpiredProduct\ Triggers - Select the trigger: trgvvvExpensiveExpiredProductInsert - Right-click and select Delete on menu - A delete object window will appear. Select OK - In the Question window click on DONE

Lab 2: Users report that they receive an error message when they execute a CLR user-defined function named: Production.ufnGetProductionInfo in the Adventureworks database. The error is occurring because the function is being denied access to the local file system. You must ensure that the least permissions possible to solve the problem are applied. Use SSMS

- Open up SSMS - Goto Server \Databases \Adventureworks \Programmability \Functions \Scalar-valued Functions - Select Production.ufnGetProductionInfo - Right-click and select View Dependencies from menu - When the window opens, select the bullet beside Objects on which [ufnGetProductionIngo] depends - In the field below select AWAssembly2 and then click on OK button - In SSMS expand the Assemblies folder and select AWAssembly2 - Right click and select Properties from the menu. The Properties window will appear. - In the Permission set field, select External Access - Click on OK. - In the Question window click on DONE

Lab 3: You are a database administrator for your company. The only non-system database on the server is AdventureWorks. A new written company policy states that nested trigger execution is not allowed. You need to ensure that this policy is implemented by modifying the appropriate server and database settings in the database properties dialog box, or both of these dialog boxes, in SQL Server Management Studio (SSMS). Perform the