Yeah, I think everyone who isn't from the US must have the same problem. Either setting the default language or using SET DATEFORMAT or using CONVERT to convert strings all...

Ok, thanks, I tried changing the logins to british and then found that whereas with 'us_english' you could enter 'mm-dd-yy' or 'yyyy-mm-dd' (which i thought went in-line with the datetime...

The yanks won waterloo???? Jeez, don't tell the french, it's bad enough them thinking we won it ...

It's not just the developers, it's users too, and there are too many...

I have exactly the same problem and can find little help with it. If no-one can come up with an answer, does anyone know of a good resource on stored-procedures...

Yes, it is very annoying. Personally, I usually just cut & paste the source View query into a new View on the target server. A bit old fashioned, maybe, but...

Well, I don't know what the problem with query designer was (tho there are CASE statements which it didn't seem to like too much) but I solved the problem by...