I know this is from over a year ago, but I've hit the same problem myself

Anyway, the brutal fix for this is described here:

If the database is not on your local machine then your local international settings will have no effect. By far the best strategy for passing dates to SQL Server is...

Thanks Andy - that's useful.

I'm actually in the process of rewriting the SP in question to use a new view instead of the temp table, which will actually work just...

Hi Andy,

I have exactly the same problem right now. You didn't find any solution did you?

Thanks,

Ric.