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

  • I have some troubles in doing following trace, thanks for kind help!

    1. aside from opening SQL profile or extended event, How to monitor or trace who and when logining SQL server ?

    2. How to know/trace who and when excecuting insert?update or delete or select statement on one table?

  • 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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • 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!

  • 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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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