Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2001
    Posts
    18

    Question Unanswered: Logging Usage (logins)?

    Hi everyone!

    Can anyone tell me if it's possible to set up some kind of a trigger that will write out to a file or a table and log details of all database connections?
    ie: user, datetime of connection, database connected to, etc.

    Any help appreciated.

    Cheers,
    Megan

  2. #2
    Join Date
    May 2002
    Location
    Cape Town , South Africa
    Posts
    30

    Cool Logins

    Hi Meagan ,

    Use SQL Profiler and run a trace you will then see which user connected to which database and at which time they did so ...and more.

    Regards
    Burner

Posting Permissions

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