MS SQL Server OLAP - Usage Analysis Like Scripted Reports

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Usage Analysis Like Scripted Reports

Brian Parker

2005-09-28, 9:23 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

Sponsored Links