InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 07:50:26 GMT20http://www.sqlservercentral.com/Forums/Topic1379607-391-1.aspxInbuilt "Schema Changes History" report can also helpThu, 01 Nov 2012 04:36:56 GMTbjcharleshttp://www.sqlservercentral.com/Forums/Topic1379607-391-1.aspxbeautiful - thanks heaps!:-)Wed, 31 Oct 2012 23:22:56 GMTdjordan 41144http://www.sqlservercentral.com/Forums/Topic1379607-391-1.aspxWoul this help ?[code="sql"]USE AdventureWorks;GOSET ANSI_WARNINGS OFF;SET NOCOUNT ON;GOWITH agg AS( SELECT [object_id], last_user_seek, last_user_scan, last_user_lookup, last_user_update FROM sys.dm_db_index_usage_stats WHERE database_id = DB_ID())SELECT [Schema] = OBJECT_SCHEMA_NAME([object_id]), [Table_Or_View] = OBJECT_NAME([object_id]), last_read = MAX(last_read), last_write = MAX(last_write)FROM( SELECT [object_id], last_user_seek, NULL FROM agg UNION ALL SELECT [object_id], last_user_scan, NULL FROM agg UNION ALL SELECT [object_id], last_user_lookup, NULL FROM agg UNION ALL SELECT [object_id], NULL, last_user_update FROM agg) AS x ([object_id], last_read, last_write)GROUP BY OBJECT_SCHEMA_NAME([object_id]), OBJECT_NAME([object_id])ORDER BY 1,2; [/code]Wed, 31 Oct 2012 23:17:50 GMTT_Dot_Geekhttp://www.sqlservercentral.com/Forums/Topic1379607-391-1.aspxthanks mate - I know what a dmv is...Do you know which particular dmv will help me?Wed, 31 Oct 2012 23:08:23 GMTdjordan 41144http://www.sqlservercentral.com/Forums/Topic1379607-391-1.aspxPlease refer :[url]http://msdn.microsoft.com/en-us/library/ms188754(v=sql.90).aspx[/url]Wed, 31 Oct 2012 23:04:19 GMTT_Dot_Geekhttp://www.sqlservercentral.com/Forums/Topic1379607-391-1.aspxwhat dmv's are you referring to?Wed, 31 Oct 2012 23:00:54 GMTdjordan 41144http://www.sqlservercentral.com/Forums/Topic1379607-391-1.aspx•On 2008: using the new Server Auditing feature•On 2005: using Dynamic Management Views (DMV)Wed, 31 Oct 2012 22:55:55 GMTT_Dot_Geekhttp://www.sqlservercentral.com/Forums/Topic1379607-391-1.aspxHi,Can you determine when a database was last modified by looking at its mdf files last modified date (i.e. on the filesystem)?If not which is the best way to determine this?Wed, 31 Oct 2012 22:10:56 GMTdjordan 41144