Enable Audit Trail for NAVISION Using SQL , How to find table data deleted by NAV User

Hi,

One of my friend, Come and tell me how to identify the user who have deleted the table data of GL Entry Table. Since we generally not enable log interaction feature of   Navision due to unnessesory growth of database. Since LOG Interaction feature was not enable he could not able to find  delted by user or modify by user.
So , How we find the user ?

We have two option :
1. We can check LDF file to identify the user : Which is generally not Easy.
2. We can use Audit trail feature of SQL Server : Easy to identify with less effort .

Now , How we  can do the setup ?

Please find the below link for setup , The step are very easy . You need to take care each step while creating audit trail.

Also let me know if find any issue in activating this .

https://technet.microsoft.com/en-us/library/dd392015(v=sql.100).aspx


or for more information

For more information:

http://msdn2.microsoft.com/en-us/library/cc280386(SQL.100).aspx: Understanding SQL Server Audit

http://msdn2.microsoft.com/en-us/library/bb630282(SQL.100).aspx: SQL Server Extended Events:

http://msdn2.microsoft.com/en-us/library/bb510667(SQL.100).aspx: Administering Servers by Using Policy-Based Management

http://www.microsoft.com/sqlserver/2008/en/us/security.aspx: SQL Server 2008 Security

http://www.microsoft.com/sqlserver/: SQL Server Web site

http://technet.microsoft.com/en-us/sqlserver/: SQL Server TechCenter

http://msdn.microsoft.com/en-us/sqlserver/: SQL Server DevCenter