NOTE:
?????
I guess it is not possible to trigger event for Truncate,but prevent it.
From msdn:
TRUNCATE TABLE cannot activate a trigger because the operation does not log individual row deletions. We can prevent truncate action,if we create a view WITH SCHEMABINDING.
If we don't use truncate on the application level, we will be dealing with only delete command. It is easy to prevent that with Instead Of Trigger.
No comments:
Post a Comment
Hey!
Let me know what you think?