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

    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.

    Regards,
    Shabber Abbas Rizvi.

  2. #2
    Join Date
    Jun 2003
    Posts
    269

    Thumbs up

    create server side trace file for security Audit events.For more information visit

    http://search.atomz.com/search/?sp-q...p-a=sp10010351
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

Posting Permissions

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