Is there any way to SEE when was my Table got Updated ? (Any Row) ?

Posted by Jasminej under Sql Server on 7/9/2013 | Points: 10 | Views : 1552 | Status : [Member] | Replies : 5

Is there any way to SEE when was my Table got Updated ? (Any Row) ?
But, I don't have enabled any Traces/Triggers on it!

Reply | Reply with Attachment

Posted by: lakhansin-22735 on: 7/9/2013 [Member] Starter | Points: 25

0	Hi, You can use magic tables (Inserted and Deleted). Lakhan Singh Tech Lead BeyondKey System Pvt. Ltd. Indore, M.P. India Jasminej, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jasminej on: 7/9/2013 [Member] Starter | Points: 25

0	Thanks for reply! We can use INSERTED / DELETED tables only if we use OUTPUT clause (at the time of actual operation) or inside the Trigger thats It! Correct ? But, Once the operation done. Now how can I ? Jasminej, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Pandians on: 7/9/2013 [Member] [MVP] Silver | Points: 25

0	We can track these information from Transaction Log. Its not mater, What kind of Recovery Mode we have used for the Database! Until the Transaction log got cleared, We can read the Info., Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Jasminej, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jasminej on: 7/10/2013 [Member] Starter | Points: 25

0	How can we read the appropriate information from Transaction Log ? Any Suggestions Please ? thanks Jasminej, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Arunkumarpollachi on: 7/12/2013 [Member] Starter | Points: 25

0	You can retrieve the details using the below query SELECT OBJECT_NAME(OBJECT_ID) AS DatabaseName, last_user_update[Last Updated Time],* FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID( 'Databasename') AND OBJECT_ID=OBJECT_ID('TableName') Thanks, Arun Kumar Arun Jasminej, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts