Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Track Usage

Status
Not open for further replies.

phil22046

Programmer
Sep 12, 2001
154
US
Manangement would like to see who is using the application that accesses the S030 database. We want to track total time logged in and get a complete list over time to see who is using the database. How can I do that?
 
Phil,
You going to have to use SQL profiler to do that. Don't run profiler from the Database server as it a resource hog. Here is a link that will help you set up that audit trace file.


- Paul
10qkyfp.gif

- If at first you don't succeed, find out if the loser gets anything.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top