Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    50

    Unanswered: Audit User Activity

    Hi All,

    I'm an Oracle DBA that has inherited some SQL Server 2000 databases.
    Can you audit a particular user in Sql Server 2000. We need to know exactly what a particular user is doing, (i.e. creating/dropping objects, and what data he is accessing)

    what is the best way to do this??

    Thanks,
    Dave

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    SQL Profiler.

    -PatP

Posting Permissions

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