Im told the filter does not work that way.

Thanks Susan,

They sent in a rep who knows very little about how to test the app. Ill look into extendint the timeout, but I dont not think that that is...

'Johnny come lately'? , 'No-one at home'?

Are you folks taking the proverbial?

Ill try the collation thing. There is no '  or anything similar....

Thanks Sush,

Ill have to get the "crap" data back again to check the ascii loop out. Should'nt be a problem to find some crap 

Folks,

Thanks for your help. I botched a fix together by pasting the strings for the names directly into SQL Server for a lookup table. The whole system needs to be...

Yep, its a varchar. I have tried manually entering the names that do not find a match, and they work. ITs only when the values are pulled from an access, cst'ed...

Cheers Bill, but I compared the len mate. I even used Soundex/Difference and found no difference.

The crazy thing is, that once I store these names in SQL Server, through my audit...

Sorry, I should have mentioned..

I have rtrim'ed ltrim' ed upper'd, everything already. Does not help 

Names that work:

Alex Labunskij

Gerry Walsh

Seamus Keane

Names that dont:

Donal McEneaney

Marcin Skupski

Piotr Warno

Thanks

M

Folks,

I cannot check this out until I get back to the office but, is database mail included with the express edition?

If so it really saves my @ss.

Thanks

Mick

Thanks Steve,

I'll report back on how it works out for me in case anyone is interested.

Cheers

Mick

Thanks Steve,

The oracle folks at my company would not allow a linked server from "mere" SQL Server. Can I use a web service as a datasource in Reporting Services? or...

Folks, Im having the same problem. I disabled 'Log Report execution' but it still happens.

Any ideas?

Mick

It appeared to be running in the service manager. But in EM it had stopped and all jobs were failing. What brought our attention to it is that a transaction...

Folks,

SQLAgent is dependent on SQL Server on that node.

That easy!

Thanks Chris