Thanks for you help!

I had to use UNC paths everywhere including Arguments and Executable.

A little inconvinient but that did the trick.

I tried adding UNC paths in the Execute Process Task WorkingDirectory, but that doesn't seem to work. The task executes without an error but it doesn't do anything.

I don't know which Select statements are causing this, but we do have a transactio table that has LOB fields and is heavely used. We don't have a alternative other...

Thanks!. I know that. But it still doesn't explain the error.

This was not happening in SQL server 2000.

Thanks everybody so much for your helpful suggestions.

I was glad to see that I'm on the right track with using Full+Diff+Logs Method.

I'll need to setup Log shipping and try it...

Thanks for the reply, Steve.

We're talking moving from California to Tennessee.

Fedex or UPS will definitely be required.

Thansk Noel,

I've tried all filters by now, Database ID/Name, Object ID/Name, Text Data.

Nothing seems to work.

Not sure what else to try.

Thanks so much for your help!

It makes sense now....I wasn't aware of the 'noise' words.

It does seem to work when passign other strings.