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!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|||Great! I didn't check in there. It looks fun!

Thanks!