var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Database activity
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!
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.
Great! I didn't check in there. It looks fun!