Is there a way to trace who inserted a particular record?

[jason1972]

How do I get the user name or host name that inserted or updated a particular record? Is this information stored in the database's log file, hidden fields, or anywhere else? I know I can add a user_name field and use triggers, but I need the information for records already existing in the table. Thanks.

Jason

 

[Cagliostro]

It deppends on configuration and database's structure/realisation.

 

[foxdev]

There are tools that can decode your log file, but I doubt you could go back very far (backing up the database or log will likely render useless the older entries). Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[cdukes]

As far as I know, there is not a way of getting the user name/host name that inserted or updated a particular record unless it has been programmed to save this data. We tend to have several columns on our tables for such data as RecordsCreatedOn, RecordCreatedBy, LastUpdatedOn and LastUpdatedBy etc.

Hope This Helps,

Chris Dukes

 

[Christine0701]

We also have added fields to certain tables --Initial entry by and Last modified by.

To get host name: host_name()
To get user name: suser_sname()

 

[jason1972]

Thanks to everyone for replying. Someone in another forum suggested the Lumigent Log Explorer. I haven't tried it out yet, but it seems to be able to retrieve user id's (and a bunch of other information) from the log file.

I wonder how these people figure out the log file format. Trial and error? Or does Microsoft publish the format?