Any way to find last table updated inforamtion

Question

Any way to find last table updated inforamtion

pawana.paul

SSCommitted

Points: 1686
More actions
May 8, 2012 at 11:59 am

#257675

Hi,
Any way to find last table updated inforamtion. I think, we can use triggers or enable auditing. Please let me know any other option like sys tables or dynamic views which holds this inforamtion.
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 1

pawana.paul (5/8/2012)
Hi,
Any way to find last table updated inforamtion. I think, we can use triggers or enable auditing. Please let me know any other option like sys tables or dynamic views which holds this inforamtion.
Thanks

If you have SQL Server 2008 R2 EE you can use change data capture, check these links:

http://www.bradmcgehee.com/2010/04/an-introduction-to-sql-server-2008-change-data-capture/

http://www.simple-talk.com/sql/learn-sql-server/introduction-to-change-data-capture-(cdc)-in-sql-server-2008/

http://channel9.msdn.com/Blogs/ashishjaiman/CDC-Change-Data-Capture-SQL-Server-2008

My blog

pawana.paul SSCommitted Points: 1686 More actions · Answer 2

Thank you very much. That's what I am looking for.

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 3

pawana.paul (5/8/2012)
Thank you very much. That's what I am looking for.

I'm glad I could help! 😉

My blog