As far as I know, SQL Server cannot audit the SELECT event using a trigger, just update, insert and delete. You might be able to concoct something using profiler though.

Dave

Marc Martin <[Email Address Removed] wrote:
Hi,

I want to implement auditing for one of the databases on our sql server 2000 installation. This particular database is a read only database so I'm interested in logging every select, by every user with the 'public' database role.

I've considered using a trigger but Isn't there an easier way? Does SQL Server 2000 have a standard utility for doing this?

thanks ahead of time,
Marc




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
MS Sql Server LazyDBA home page