Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2008
    Posts
    117

    Unanswered: Transaction Log with sql server 2008

    hi,
    I have several number of user login with my sql server 2008.
    Can i able to track what are all the users transacting with sql server like selecting,inserting,deleting,updating etc. with corresponding date,user, database, tables ?
    Is there any inbuilt functions for taking logs ?
    I tried DBCC logs('db_name'). I am not sure whether i am getting correctly the one i need.
    thankyou

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You will need to use SQL Profiler to capture any select activities. You can also generate a script for a trace, and have it run on the server itself, if you have such stringent auditing needs.

Posting Permissions

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