Skip to content Skip to sidebar Skip to footer
Home / Sql Server / Sql Server 2005

How Can A Table's Last Modified Date Be Returned In Sql Server 2005?

Post a Comment
How can a Table's Last Modified date be returned in SQL Server 2005? I did see one on the Table Properties page. There is a Created Date but no Modified date. If it is not availabl

Solution 1:

This Blog entry contains information on how to do it on SQL Server 2008 and 2005.

  • On 2008: using the new Server Auditing feature
  • On 2005: using Dynamic Management Views (DMV)

SQL Server 2000 has no built-in possibility to do it, so you'll need a workaround, like you already mentioned.

Solution 2:

Paul Nielson's AutoAudit is a quick and effective way of retro-fitting this to a database. He has a demo screencast here.

Post a Comment for "How Can A Table's Last Modified Date Be Returned In Sql Server 2005?"