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 : 775 | 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!




Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response