![]() This is one of those circumstances where you need to use a context-sensitive trigger. How do I go about with something like this? Is this possible? What is a decent way to get this behaviour? This I can work around by defining a constant paramater to trigger but cannot do it when the transaction is open. Trigger can be fired when: SPID and transaction id = constant values. The reason being that I am hoping to log open transactions to avoid UPPER QUALIFIED GUARANTEE VIOLATIONS as my investigation states that SPID's with a high UD POINTS value can cause an event to be fired within a statement (not for a transaction). I need to write an audit trigger that cannot be fired for an open transaction. ![]() How to create a trigger that cannot be fired for an open transaction Download the full cracked version which includes VideoCopilot Element 3D, Import3d Element/3D File Converter, 1.4.4.20 with Element 3D 2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |