As far as I know, there is nothing "out of the box" as far as making message audits more queryable (I have already made that request).
But given that, I THINK SQL 2008 might provide a better embedded CLR experience. I have been thinking about trying to create a read-only view of the audit tables that would use CLR integration to break apart the message field into separate columns. I do not know if this is even possible (but it should be, if it isn't).
Taking this approach, should not cause any Neuron internal errors, and at the same time open the door for more useful (searchable) audit investigation.
We have set up an ODBC adapter to poll a stored proc.We found that if the stored proc has a temporary table defined the rows returned are always 0.Any idea why this would be and what we can do to get around it?See More