Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jan 18, 2005

MSSQL Server Reporting Services: Black Belt Administration: Prepare the Execution Log for Reporting - Page 3

By William Pearson

Hands-On Procedure


Create a Folder and Populate it with the Components We Will Need

To prepare for our session with the Execution Log, we will create a folder to house the DTS package to which we have referred earlier, along with other files that we will need to complete our practice exercise. Working with copies of the files will mean that we can comfortably proceed in a practice environment without concern about "returning things to the way they were," should we later wish to perform similar exercises in our development or production environments (where it would obviously be appropriate to maintain proper source control over the respective objects). The folder can be created anywhere on the PC that is convenient from a local perspective.

1.  Right-click Start.

2.  Select Explore to launch Windows Explorer.

3.  Navigate to a convenient place to create the folder that will contain the "collateral" for our practice session.

4.  Create a folder named as follows:


The folder appears similar to that depicted in Illustration 1.

Illustration 1: New Folder in Place to House Lesson Components

5.  Navigate to the following folder (or it's equivalent, if your installation differs from default):

C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\ExecutionLog

The folder should contain the following four files:

  • cleanup.sql
  • createtables.sql
  • rsexecutionlog_update.dts
  • rsexecutionlog_update.ini

6.  Using SHIFT+Click, select all four files noted above.

7.  Right-click the highlighted selection.

8.  Select Copy from the context menu that appears, as shown in Illustration 2.

Illustration 2: Select Copy from the Context Menu

9.  Navigate to, and enter, the RS013 folder we created above.

10.  Right-click within the folder.

11.  Select Paste from the context menu that appears, as depicted in Illustration 3.

Illustration 3: Placing Copies of the Components into the New Folder

Copies of the four files appear in the new folder.

We are now ready to create a database to house the data from the Execution Log. In doing so, we will make use of the files we have placed in the folder we created in this step.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM