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

    Unanswered: Last connect/update/modify date

    Hi all,

    Could anyone give me any information on how to obtain information from my SQL Server db's that will indicate the date of last connection/update/user activity?

    Many thanks,
    Megan

  2. #2
    Join Date
    Jul 2002
    Posts
    229
    There are SP's and other ways to list some info about what's happening right now in the database, but I can't find anything about what happened earlier.
    Maybe a log explorer tool could help with some parts.

  3. #3
    Join Date
    Oct 2001
    Posts
    18
    Thanks for the response

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Under Management -> Current Activity, will give you some information. You can also enable successful/failed login auditing - this is probably what you will need to enable as well as using sql profiler.

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    The following is a good article:

    article

  6. #6
    Join Date
    Jul 2002
    Posts
    229
    Is the contents of that web site the same as in Books On-Line?

  7. #7
    Join Date
    Jul 2002
    Posts
    229
    > You can also enable successful/failed login auditing

    Where do I do this?

  8. #8
    Join Date
    Feb 2002
    Posts
    2,232
    SQL profiler is the best tool for this - but you can also use auditing under the sql server properties -> security -> "Audit Level". Under SQL Profiler - Create a trace -> Events - you will see several auditing choices.

  9. #9
    Join Date
    Oct 2001
    Posts
    18
    Thanks to all who responded!

    I ended up creating a custom trace template in Profiler and create my trace files based on it.
    It's not awe-inspiring, but it's the only solution I've come across so far without looking at purchasing some kind of 3rd party log-miner/auditing software.

Posting Permissions

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