There is lots of information out there to setup your own auditing. Typically it is used to track modifications, deletions, and additions though and not views of data. You could easily do that as well though.
There are also numerous tools out there you can use which will do it for you. Just google it.
>Hi there, anyone know of a way to ascertain who is accessing tables/views in SQL 2000 ?
.·*´¨) .·`TCH (..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100 "When the debate is lost, slander becomes the tool of the loser." - Socrates Vita contingit, Vive cum eo. (Life Happens, Live With it.) "Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown "De omnibus dubitandum"