Fire triggers on SELECT

Question

I'm new to triggers and I need to fire a trigger when selecting values from a database table in sql server. I have tried firing triggers on insert/update and delete. is there any way to fire trigger when selecting values?

Solution

There are only two ways I know that you can do this and neither are trigger.

1. You can use a stored procedure to run the query and log the query to a table and other information you'd like to know.
2. You can use the audit feature of SQL Server.

I've never used the latter, so I can't speak of the ease of use.