Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Column value changed? Expand / Collapse
Author
Message
Posted Thursday, October 21, 2010 6:11 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 19, 2014 3:48 AM
Points: 10, Visits: 74
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
Posted Thursday, October 21, 2010 6:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 9:50 AM
Points: 5,367, Visits: 9,913
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
Posted Thursday, October 21, 2010 6:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 19, 2014 3:48 AM
Points: 10, Visits: 74
Thanks for you reply.
A trigger would be a more appropriate solution.

Post #1008386
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse