| Deepak Puri 2006-01-31, 3:23 am |
| Hi AJ,
If you're referring to Reporting Services, this article by William
Pearson should help:
http://www.databasejournal.com/feat...cle.php/3459461[color=darkred]
January 18, 2005
MSSQL Server Reporting Services: Black Belt Administration: Prepare the
Execution Log for Reporting
By William Pearson
...
the Report Server Execution Log is a great place to start in setting up
a basic performance and auditing analysis capability.
The Execution Log captures data specific to individual reports,
including when a given report was run, identification of the user who
ran it, where the report was delivered, and which rendering format was
used.
In this session, we will:
Discuss Execution Logging in general, and the steps involved in creating
a useful data source for reporting purposes from the log as it appears
in its native form;
Discuss potential complementary functions we can leverage from
implementing Execution Log reporting;
Create a database to store the Execution Log data;
Navigate to the location of the files provided with Reporting Services
to assist us in transforming Execution Log data to a useful reporting
data source;
Open and execute the table creation script provided to create the schema
for our new reporting database;
Load and execute the DTS package provided to transform the Execution Log
data and to populate the new database tables.[color=darkred]
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.droptable.com ***
|