re: SELECT TRIGGER
My post today at: microsoft.public.sqlserver.programming...
Perhaps there hasn't been a groundswell of interest since in the past, it
was not seen as technically practical.
However, as you indicated, since the underlying architecture has changed,
and it may not be overly complex to implement, I think that there is a
growing 'real' market need -that will grow into a strong demand in a
relatively short time.
You only have to deal with HIPPA, where all data reads containing patient
medical information MUST be logged, to quickly understand the need for a
SELECT trigger. I suspect that upcoming regulatory approaches concerning
data privacy (read: identity theft) will obviate a need for SELECT triggers
with concomitant logging.
I agree, it is easy to do the logging using stored procedures, and I require
all data access to be through stored procedures. But the majority of .NET
applications being created, using Microsoft tools, instructions, and
examples, are using direct table (or view) access in the DAL with SELECT
Put me down as one who supports adding a SELECT trigger to the wish list.