User wise Query Tracking

• vs.satheesh

  SSCrazy

  Points: 2392

  More actions

  April 30, 2015 at 4:24 am

  #317190

  Hi ,

  In my production server i created sql server user for limited permission.Now i want details of what are all the Query executing in user wise .

• Grant Fritchey

  SSC Guru

  Points: 398890

  More actions

  April 30, 2015 at 6:04 am

  #1794628

  Use extended events[/url]. They have great filtering and can capture just the queries executed by a given user.

  "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