SQLTeam.com | Weblogs | Forums

How to examine logs

Hi,

I wonder if I can see which user enters the database, what did he do (select, insert, update) and when he did. Is there a way to get those infor? By the way I am admin on the server.

Best Regards.

the most common way to capture that information is through extended events. It has events for logins, data changes, and SELECTs. That's going to generate LOTS of data unless you filter it down by user.

But that's something you'll need to configure to capture those events. It isn't on by default.

How can I configure?