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 ..
Sql query
how to fin the list of the operation performed on the table according to the date
trilok pathakPosted Apr 17, 2013, 2:01 AM
but can you tell me any site so i can take reference from it
thank in advance and hv gd
trilok pathakPosted Apr 17, 2013, 1:58 AM
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 PandeyPosted Apr 15, 2013, 1:11 AM
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 TrivediPosted Apr 14, 2013, 11:58 PM
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.