Create a Database to Contain the Execution Log
next step is to create a database to contain the information from the Execution
Log. As we have discussed, Reporting Services creates a log to house this
information already - a log that we might simply access, and from which we
might report, without the need for an "intermediate" database. The
information that we find in the default database leaves a little to be desired
from the perspective of formatting, ease of reporting and so forth. We will
therefore take a gift as it is presented, and use the tools provided to create
a database and user-friendly schema to make our job easier. We can, after all,
modify the database as required in the future, should the need arise, based
upon client feedback or our own inclinations.
begin the construction of our reporting data source, we will first create a new
database from the MSSQL Server Enterprise Manager, and then create the
constituent tables of the database with Query Analyzer. This step will
be facilitated by the table creation script that resides among the components
that we placed into the folder we created above.
the Microsoft MSSQL Server Enterprise Manager shortcut in the Programs
group, as appropriate.
equivalent on my PC appears as shown in Illustration 4.
Illustration 4: Navigating
to the Enterprise Manager
Manager from the menu.
Manager console opens.
Microsoft SQL Servers by clicking the "+" sign to its
immediate left, as required.
Manager console appears as depicted in Illustration 5.
Enterprise Manager (Compressed) View
Expand the Databases
folder, so as to display its contents.
the Databases folder.
Database ... in the context menu that appears, as shown in Illustration 6.
Illustration 6: Select
New Database ...
Properties dialog appears, defaulted to the General tab.
following into the Name box:
tab of the Database Properties dialog appears
as depicted in Illustration 7.
Illustration 7: The
Database Properties Dialog - General Tab