SQL Server Performance

list of all status values of ExecutionLog in SSRS

Discussion in 'SQL Server 2005 Reporting Services' started by Anirban Biswas, Feb 18, 2008.

  1. Anirban Biswas New Member

    Hi,
    I need to know all the possible 'Status' values of the ExecutionLog in repoting services.
    Is there any way to find it?
    presently when i am using..... select
    distinct Status from ExecutionLog
    I get the list of values, but I want to get the Possible list of values.
    Can any one help me out...??
    Anirban Biswas, Feb 18, 2008
    #2

  2. satya Moderator

    satya, Feb 18, 2008
    #3

  3. Anirban Biswas New Member

    When I am using select distinct I am getting these result.....
    rsJobWasCanceled
    rsInternalError
    rsReportParameterValueNotSet
    rsParameterError
    rsReportTimeoutExpired
    rsProcessingAborted
    rsSuccess
    rrRenderingError
    But I want to get all the possible list. Is there any master table for this?
    With regards
    Anirban Biswas, Feb 18, 2008
    #4

  4. Anirban Biswas New Member

    Anirban Biswas, Feb 18, 2008
    #5

  5. satya Moderator

    That is specific to SQl2000 version and you should mention that before in order to referring sql2005 links.
    satya, Feb 19, 2008
    #6

Share This Page