SQL Server Performance

SQL Server 2000 - Capturing Real Time User/Login information

Discussion in 'ALL SQL SERVER QUESTIONS' started by sqlderby, Jan 7, 2014.

  1. sqlderby Member

    Hi

    I need to capture user/login access information (real time) e.g. every 5 mins in the table to audit monthly basis.
    I have explored the option on net and MS Tech sites but could find any head start or script examples.

    Pls help
    Thanks
  2. Luis Martin Moderator

    What about Profiler using Security Audit Events?
  3. sqlderby Member

    Thanks Luis...

    I want to do using scripting as it is production server and recommendation is not run profiler on production. am I right?
  4. Luis Martin Moderator

  5. sqlderby Member

    Thanks Luis...I will follow with 2000 and let u know if works or need any further help.

Share This Page