Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Location
    Montréal, Canada
    Posts
    28

    Unanswered: Database activity

    Hi,

    I'm looking forward to trace the activity on my database, like seeing how many connection were opened on my DB by this or this account from startDate to endDate.

    I wonder if SQL Server 2000 offers tools, or if I can build some request in some system tables, or if I have to use a side application...

    If anybody can help, he's welcome!
    Data Climber

  2. #2
    Join Date
    Jun 2002
    Location
    USA
    Posts
    21
    Hi,

    SQL Server has "SQL Profiler" Tool. You can use it to trace any activities on Database or an application.

    Click Start-> Programs->Microsoft SQL Server-> Profiler.

    For more info, see BOL.

    Have Fun

    Varad01

  3. #3
    Join Date
    May 2002
    Location
    Montréal, Canada
    Posts
    28
    Great! I didn't check in there. It looks fun!

    Thanks!
    Data Climber

Posting Permissions

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