InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 02:04:39 GMT20http://www.sqlservercentral.com/Forums/Topic1008374-391-1.aspxThanks for you reply.A trigger would be a more appropriate solution.Thu, 21 Oct 2010 06:27:11 GMTSQL_Padwaanhttp://www.sqlservercentral.com/Forums/Topic1008374-391-1.aspxUnless you already had something set up to track changes on your tables, there is no way of doing what you require. For the future, create triggers on those tables that you need to know who changed what and when, and write this information to separate tables.JohnThu, 21 Oct 2010 06:16:59 GMTJohn Mitchell-245523http://www.sqlservercentral.com/Forums/Topic1008374-391-1.aspxHi guys, I am currently working on an application that updates a status (INT). I need to know when that status was last changed (DateTime) as there is no datetime stamp and this is not stored anywhere within the table.I have looked at the sys.traces but no luck and sys.trace_columnsAny ideas please?CheersThu, 21 Oct 2010 06:11:17 GMTSQL_Padwaan