Fire triggers on SELECT

select, sql-server, triggers

Solution

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

- 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.

- 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.

Problem

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?

Original source