Column value changed?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Column value changed?

Column value changed?

Rate Topic

Display Mode

Topic Options

Author

Message

SQL_Padwaan

Posted Thursday, October 21, 2010 6:11 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 18, 2012 9:51 AM
Points: 10, Visits: 67

Hi 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_columns
Any ideas please?

Cheers

Post #1008374

John Mitchell-245523

Posted Thursday, October 21, 2010 6:16 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Tuesday, June 04, 2013 7:03 AM
Points: 4,443, Visits: 7,249

Unless 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.

John

Post #1008378

SQL_Padwaan

Posted Thursday, October 21, 2010 6:27 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, April 18, 2012 9:51 AM
Points: 10, Visits: 67

Thanks for you reply.
A trigger would be a more appropriate solution.

Post #1008386

« Prev Topic | Next Topic »

Permissions