Hunting for select * with Extended Events

After a question from Alex Whittles (t|w) during my Extended Events session at the Leicester SQL Server User Group

Stuart Moore

Stuart Moore

Nottingham based IT professional with over 15 years in the industry. Specialising in SQL Server, Infrastructure design, Disaster Recovery and Service Continuity management. Now happily probing the options the cloud provides

When not in front of a computer, is most likely to be found on the saddle of his bike

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

2 Responses to Hunting for select * with Extended Events

  1. Mohanraj Jayaraman August 16, 2013 at 05:27 #

    like_i_sql_unicode_string does this predicate exists in SQL 2K8 R2 ? if not exists how to make use of like operator in the extended events.
    My requirement is to capture the application name otherthan .Net Sql Client using Extended Events.


    • Stuart Moore
      Stuart Moore August 19, 2013 at 07:43 #

      Hi Mohanraj,
      Unfortunately the like predicate comparisons were only introduced with SQL Sever 2012.

      Are you just wanting to capture this information for audit purposes? Or do you need to capture it live for problem analysis?

      If it’s the former then a logon trigger might be solution for you.

      For the latter I can think of a couple of possible solutions, but a lot would depend on exactly what you were tracking as that would affect exactly where in the session I’d want to be filtering the data to get the least impact on performance.


Leave a Reply