I'm a SQL Server 2008 user. I have access to some tables. I need to request few columns from table as I usually do. But I need to do it once (for example) in 5 seconds and system administrators shouldn't see (feel:) my activity.
Result of request - table with approximately 100 lines. My query contains only select and where clause by index. (it is light and it is executing very fast)
As I know,
SELECT operations don't write to transaction log. I mean, if I only read database, where is log of my select actions SQL Server keep? Can administrator see my select queries?
C2 audit, as I can see in properties, is disabled.
Is there any other ways to see my activity?