I would like to find a way to capture update, insert and delete details of an SDE table (non-spatial) and insert into an audit table in sql database.
Thanks in advance!
You may want to take a look at Geodatabase Archiving:
Geodatabase archiving—ArcGIS Help | ArcGIS Desktop
This will record all of your edits. You will see an additional table in the database with an _H. This table records all the archived information.
Retrieving data ...