SQL Server Performance Forum – Threads Archive
Database AccessHow 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.
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.