Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jay123
Yak Posting Veteran
54 Posts |
 Posted - 2010-04-14 : 06:51:15
|
| i was wathcing a simulation example for the 70-431 sql test.the question was:a new wriiter 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 proerties dialog box of the serber properties dialog box, or both of these dialog boxes, in sql server managementstudio (ssms). so in the server properties you see him set "allow triggers to fire otheres" to false.he then goes into database properties and sets "recursive triggers enabled" to True.I dont understand why he need to do this last part. If "trigger execution is not allowed" why does he set this to True. Thanks...also if anyone has any links, or tips about this exam i would appreciate it. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-14 : 08:12:46
|
1. If a trigger performs a statement that fires the same trigger again - that's recursive.2. If a trigger performs a statement that fires another trigger - that's nested.So in relation to your posted question it is correct to make the server setting and IMHO it is regardless of which setting is for the database.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-04-15 : 06:25:19
|
| Jay, you may want to edit your post and remove the question. By posting it in public you have violated the NDA that you accepted before writing the exam. That can result in you certification being revoked and even blacklisted from further certifications permanently.If this was not taken from the exam, then clarify where it comes from.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
Question about 70-431 exam.