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 |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2008-12-27 : 21:27:57
|
| also, can someone please give me a pointer to where to learn about the internals of triggers?That is, how triggers are programmed. I am specifically interested in the point in which sql server catches the request for, say, an insert, and before it is executed, it transfers control to the trigger mechanism that creates the inserted temp table.And even more specifically, I would like to know what is the signal that sql server listens to when this insert is requested? where does this signal comes from, how is it generated, who generates it, how it is received, which component receives it, etc...thank you for your help, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
heze
Posting Yak Master
192 Posts |
Posted - 2008-12-30 : 21:06:25
|
| Thank you for your comments,Well, I am reading this article, and it describes the architecture of SQL Server 7.0, does anyone knows if the architecture described here (in the first paragraphs) is still the same or at least similar to the 2005 and 2008 versions?http://msdn.microsoft.com/en-us/library/aa226174(SQL.70).aspxthank you |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-31 : 22:12:06
|
| Like Tara said, You have to contact microsoft SQL Genius who wrote/implemented about Triggers? Only he has real answer. Like Paul,who knows internals about Corruptions because he wrote for it. |
|
|
|
|
|
|
|
|
internals of triggers