database usage report (reply)
Run SQL Profiler.
It will give u a complete detail of everything
------------
Sri at 5/22/2002 8:43:42 AM
Hi,
I have a requirement to create a Database usage report. The report should have - userid, user name, login time, database to which he has logged in, log out time, host machine id.
How do I go about generating this type of report. What system tables are to be refered?
Please help.
Thanks
Sri
database usage report (reply)
Refer to SysProcesses table in the Master database.. You have all the info in this...
Hope this Helps..
Venu
------------
Sri at 5/22/2002 8:43:42 AM
Hi,
I have a requirement to create a Database usage report. The report should have - userid, user name, login time, database to which he has logged in, log out time, host machine id.
How do I go about generating this type of report. What system tables are to be refered?
Please help.
Thanks
Sri