Sql query

Question

how to fin the list of the operation performed on the table according to the date

like on table employeemaster which operation is done like insert or update or delete kind of operation performed on the specified date.

thank you in advance ..

trilok pathak · Answer

@ pradip thank you for your reply but can you tell me any site so i can take reference from it thank in advance and hv gd

trilok pathak · Answer

no sir what i want like if i am giving the name of the table so query should return me like which operations are performed on it

Pradip Pandey · Answer

Hi Trilok You can do this by using your custom logic. For any kind of operation always insert a record in the table along with status i.e 'I'.'E''D'. So now you will have all the records in the table related with the activities. Hope it will help.

Jignesh Trivedi · Answer

hi you mean to say audit log type of functionality? you can find it out from log file (.LDF) we can read the log with (DBCC LOG and fn_dblog). http://killspid.blogspot.in/2006/07/using-fndblog.html http://www.confio.com/logicalread/sql-server-dbcc-log-command-details-and-example/#.UWt5-jcWjHo also you can put you extra logic to track this like use CDC or custom change track mechanism. hope this will help you.