[TimeTag] How it works

[TimeTag] How it works

  
Forge Component
(7)
Published on 2013-05-06 by José Serôdio
7 votes
Published on 2013-05-06 by José Serôdio
This component was developed on a permisse that the developer does not have to borrow about coding to grant historical entity data.

Currently we are using with multiple catalogs and did not identify any bug.
 
The "Hack" to ensure that it is possible to create the triggers was the same used by the "Track Changes", here are our thanks because it was very useful and served for inspiration.
 
The application uses a session variable to pass the SQL user's session webrequest to SQL (SET CONTEXT_INFO) http://msdn.microsoft.com/en-us/library/ms180125.aspx .
As a result we can have access on the SQL at the Trigger the user that affects the records during that transaction.
 
Suggestions for improvement are welcome.