Database and Tables Access Logs

Question

Hi,

How do I check if someone is accessing a DB or table? Is there a way to see logs of people running select queries and other queries against DBs and tables?

Thank you.

Answer 1

Hello,

By default SQL Server don't log such Information, you have to implement an auditing on your own.

=> SQL Server Audit (Database Engine)

---

Olaf Helper

[ Blog] [ Xing] [ MVP]

Answer 2

Turn ON sql server profiler and filter out desired database.

---

Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

MS SQL optimization: MS SQL Development and Optimization
MS SQL Consulting: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
SQL Server Integration Services: Business Intelligence

Answer 3

What's a sample event I should see in the event log, say the configuration is in place.

Answer 4

Refer the below link

http://www.databasejournal.com/features/mssql/article.php/3887996/Determining-Object-Access-Using-SQL-Server-Profiler.htm

--Prashanth