title: SQL server, 'before-select' event
body: <p>I understand that this question was asked a million times already. I do understand how triggers work in SQL Server. But may be there're some new workarounds which I haven't found yet.
  So I'm trying to understand if there any way of catching SQL server <code>select</code> statement from table/view/function event and execute some sql statement beforehand. </p>
  
  <p>So far the closest way of doing this I found is - run profiler which will put all the data to table, create trigger on this table, run procedure from this trigger.
  Unfortunately, even this crazy method didn't work, profiler just fails the moment the trigger tries to fire.</p>
  
  <p>Are there any other crazy ideas I'm missing?</p>