Question : How to Monitor User Connection to My Database in SQL 2000 and SQL 7.0?
I need to auditing keep track of the activity performed on my database. Only authorized users have access to my database.
database auditing

Best answer:

Answer by Maku
In the Enterprise Manager, navigate to “Management” in the console tree.

Click on “Current Activity”, then “Process Info”

Data is presented as:
Process ID, Context ID, User, Database, Status, Open Transactions…etc

Or

You can query the “sysprocesses” table in the master database

Hope this helps.

Maku