• Thanks Michael,I again have got the solution.Below is the ouput I got.

    Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

    Oct 14 2005 00:33:37

    Copyright (c) 1988-2005 Microsoft Corporation

    Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

    Michael,I have one more query regarding Querying and Reporting on Report Execution Log Data.It is said that using the DTS package the contents of the Report Server Execution Log can be copied into a set of user-defined tables.The location of the DTS package as given in SQL Server 2005 Reporting Services Black Book is c:\Program Files\Microsoft SQL Server\80\Tools\Reporting Service\ExecutionLog.But i couldn't get the package instead I got some Package folder in c:\Program Files\Microsoft SQL Server\90\DTS\Packages. I also got in technet.microsoft.com the following:

    "A sample database script file is provided that creates the table structure used by the package. The following files are used to create the database and extract data:

    RSExecutionLog_Update.dtsx

    RSExecutionLog_Update.dtsConfig

    Createtables.sql"

    But I am unable to find the above anywhere.So Michael could you please help me in resolving this issue.