Simulation Question #1
You work as a database administrator at TestKing.com.
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.
The only table that the view uses is named Production.ExpiredProduct. The table has the following definition:
CREATE TABLE Production.ExpiredProduct {
ExpiredProductIDINT IDENTITY CONSTRAINT PK_EXPIREProduct PRIMARY KEY
, Name NVARCHAR(50) NOT NULL
, ListPrice MONEY NULL
}
You need to ensure that insert statements can be complete successfully. You need to apply the fewest possible changes, and you must use SQL Server Management Studio (SSMS).
Answer:
In order to arrive to the solution of this question the following steps must be carried out:
1. To go on the sight specified in the questionnaire (like as an example in this case Production.ExpiredProduct)
2. open the folder of the trigger
3. Delete the trigger
