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...??
See these are any help: http://technet.microsoft.com/en-us/library/ms156500.aspx http://www.sql-server-performance.com/articles/biz/execution_log_reporting_data_source_p1.aspx
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
I believe this is the link I was looking for........ http://msdn2.microsoft.com/en-us/library/aa256058(SQL.80).aspx
That is specific to SQl2000 version and you should mention that before in order to referring sql2005 links.