InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 02:59:34 GMT20http://www.sqlservercentral.com/Forums/Topic1392401-146-1.aspxThanks a lot.it is really helpfullTue, 04 Dec 2012 06:37:49 GMTsenfriends2008http://www.sqlservercentral.com/Forums/Topic1392401-146-1.aspx[quote][b]sanket kokane (12/4/2012)[/b][hr]to get file create date[code="other"] xp_cmdshell 'dir <your Datafile Path> /tc'[/code]or right click on data file at physical location and check create time[/quote]Wonderful. :) Sometimes we need to think simple :)Tue, 04 Dec 2012 06:19:41 GMTarunyadav007http://www.sqlservercentral.com/Forums/Topic1392401-146-1.aspxto get file create date[code="other"] xp_cmdshell 'dir <your Datafile Path> /tc'[/code]or right click on data file at physical location and check create timeTue, 04 Dec 2012 06:17:50 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1392401-146-1.aspxHello,Not sure if you can get the info for files added/ altered alreadt but to track the changes in future, you need to configire DDL triggers to capture this information.Check the below link for more info...http://www.mssqltips.com/sqlservertip/2085/sql-server-ddl-triggers-to-track-all-database-changes/Tue, 04 Dec 2012 06:17:35 GMTarunyadav007http://www.sqlservercentral.com/Forums/Topic1392401-146-1.aspxhow to find sql server database file create and alter date and timeplease help usTue, 04 Dec 2012 05:55:01 GMTsenfriends2008