SQL Server Performance Forum – Threads Archive

Database Access

How can I monitor access to the database? Is there some type of syslog that shows me that type of activity?

If you are looking for logins, you can use Profiler, and trace for Logins and Logouts.

Agree. If you need more information, there is a good 3rd party software. Take a look our sponsors.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

SP_WHO2 is the best statement to monitor the connections against the databases, if you’re looking to record the events on the access of database then better to use server side trace or if budget allows third party tools as referred. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>