Oh heck yeah! That's it!

I tried "[*]" but actually needed "*[*]*". Thanks wolfkillj!

Your solution worked. In my expression, I did a replace() on the field and searched for the new character.

I'd like to keep this post open to see if...

Yes, I have tried both: [*] and "**".

I also tried preceding the asterisk with the following characters:

~`!@#$%^&*-_+=<>?/\|

So for example:

blah, blah, blah... Fields!MESSAGE_TEXT.Value like "\*"

No success.

I found this solution online:

[/url]

Basically, I needed to use the Oracle Provider for OLE DB instead of the Oracle Provider.

My query fails in Query Designer with...

I think you're getting closer to my problem. Oracle doesn't like the format (or data type) of the parameter when passed to the SQL statement. I'm not writing...

Thanks for your reply but I don't think that's the problem.

My query runs fine in Reporting Services' Query Designer. Here's the statement:

select distinct

originating_timestamp,

message_text

from

...

We had windows updates go in last night so all servers rebooted and flushed all traces as you said they would. Spotlight then created one new trace for all...

That's it! I had a start up procedure that enabled xp_cmdshell, ran some scripts, and then disabled it. I removed the disable statement.

Thank you!