Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005

    Unanswered: Maintaining a log for the users connected to sql server db.

    Hi !

    I need to maintain a record such as how many time any user (e.g, sa) connects to the sql server. Means whenever any person is connecting to the database through application or directly, then i need to know that through which sql user(e.g sa), any body connected.

    Shabber Abbas Rizvi.

  2. #2
    Join Date
    Jun 2003

    Thumbs up

    create server side trace file for security Audit events.For more information visit
    I love cursor,though I never use it.Cos' I dont want to misuse it.


Posting Permissions

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