How to do the following trace one a database server and on a table?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 1

The answer to both questions is Extended Events. That's what it's there for. Why would you NOT use it?

There is SQL Server Audit for the logins (not query calls), but guess what it uses under the covers to do it's job? Yes, Extended Events.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

892717952 SSC Eights! Points: 843 More actions · Answer 2

thank you Grant Fritchey!

I just want to know if there is another way to do it. I know extended event can do it. thanks!

Grant Fritchey SSC Guru Points: 398882 More actions · Answer 3

Well, that's the answer to your questions.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt