Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Do log files store user/host names?

Author  Topic 

jason1972
Starting Member

1 Post

Posted - 2001-03-02 : 21:48:01
Is there a way to get the user or host name responsible for inserting or updating a record? Is this information stored in the log file or anywhere else? I know I can add a user_name field and use triggers to implement this, but I want to get this information for records already existing in the table. Thanks.

Jason

   

- Advertisement -