Usage Analysis Like Scripted Reports -
09-28-2005
, 08:33 AM
When using usage analysis in analysis services SQL2K to view the queries
issued by certain users, the results sometimes run off the screen and I
cannot see them all. I need to see them all to see exactly what queries are
being run. Since I cannot save the results of the Usage Analysis queries,
I'd like to find or create some scripts I can run that give me the results in
a form that I can save to disk.
I would prefer if the script examples were .NET based. I do not have Visual
Studio 6 installed on my box. Does anyone have any examples or at least
direction in regards to this.
Regards, Brian Parker |