>>Can anyone think of a way to track Wow, when and what the select statement was for ANY individual who hits a Data Warehouse?
>>
>>This is part of a Federal Compliance with medical data.
>>
>>TIA
>>
>>__Stephen
>
>You could create your own "front-end" to the data. If you use SPs, you can program in any auditing information you want.

We have Cognos, Access, Excel already as front ends into our data marts. We were looking for something on the server side to act as a triger.

__Stephen