Need help on this simulation question | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Need help on this simulation question

Simulation Question You work as a database administrator at your company. Users report that insert statement against the view name Production.ExpiredProduct 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 {ExpiredProductID INT IDENTITY CONSTRAINT PKEXPIREProduct PRIMARY KEY
Name NVARCHAR(50) NOT NULL
ListPrice MONEY NULL} You need to ensure that the insert statements can be complete successfully. You need to apply the fewest possible changes, and you must use SQL Server Management Studio(SSMS). What is the possible solution for that? I go to delete the only Trigger in the Triggers folder, is it correct? Or should I disbale it? Or is it any other Solution? Please help.
Do not succeed means what, do you get any error. If so check if that is violating any primary key or unique constraints in this case. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
This is the question in the exam. It only given us this scenario, just say that did not succeed but the insert statement is valid. It open the SQL Server Management Studio (SSMS) with some functions available only. Based on the question, what you suspect? Anything to do with view? Table Key or Triggers? Kindly advice. Thanks.
The suggestion is to find it yourself by referring to the books & available resources on your lab, it is best to discourage give the answers for the exam here, dont’ get me wrong but by experience you will be at best by researching it. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
What "exam" are you talking about? —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
FYI, I have try but I still unable to figure out the answer given by my teacher in practice lab.
What was the answer by your teacher? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
He didnt give out the answer yet…but I suspect is due to the Trigger that block the insert statement not work, FYI, only 1 trigger in the table. So I proceed to delete the trigger. Not sure correct or not. In this case, normally we disable or delete trigger? Which one better or also depend?
The easiest way to get rid of the problem is to delete the entire database. Yep, Friday sarcasm.
]]>