var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to retrieve historical user queries
Can anyone help me with the following requirements please.
I have DWH where users query on regular basis. I wanted to know what queries they run and which user fired the queries for the last one month or 6 months.
Please let me know how to achive this.
If you're not already recording this data then you can't get it!
One option to log this information is to use SQL Profiler and run a trace however you must note that this will affect your server performance.
As for logging who is performing the queries; that really depends on how they are accessing your data: Windows or SQL authentication.