Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Posts
    55

    Unanswered: How can I know who inserted a certain record??

    Dears,
    I have either a service or even a user who keeps adding records to a certain table. Is there any way to know who added the records? Other than using the SQL Profiler.

    Thanks,

  2. #2
    Join Date
    Sep 2003
    Location
    Australia
    Posts
    6

    Re: How can I know who inserted a certain record??

    To collect statistical information about users, use either SQL Profiler or System Monitor (Windows NT Performance Monitor in Windows NT® 4.0). Use the SQL Server Enterprise Manager Current Activity window to perform ad hoc monitoring of SQL Server, which allows you to determine user activity on the system.

    Also, type this into the Books Online Search "Monitoring with SQL Server Enterprise Manager"

    Also, is there a lock for the INSERT???

    Hope it helps...

  3. #3
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: How can I know who inserted a certain record??

    Just add a column with as default User
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •