Jeff,

That was a great post - thanks for that.

The ConnectionString property is an amalgamation of all the other properties of the connection manager. I don't know which has priority but...

Don't know about 1 and 2.

Regarding 3...what error message are you getting? I am storing my connection strings for Oracle (and lots of other things) in config files and its working...

It seems to me standardisation is the key. I hate to turn real-world discussions into something techie but this is a techie site so...

This is a real benefit that XML...

Yelena,

The use of the word "option" (N.B. not "Option") was meant colloquially rather than being offical terminology. Given the choice of answers it was pretty clear what the question was...

The moment you asked the question I immediately thought "War Games". And whilst I acknowledge the brilliance of "The Matrix" it has to be War Games for me.

Not sure if...

Patrick,

Surely the point of QoD isn't to get it right, its to learn something new. Well, that's my opinion anyway and I write the questions with this in mind.

Hopefully you have learnt...

[Just putting this here so I know if someone replies or not]

Guys,

Thank you for the help. I used Noel's code and proved the theory  'British' does indeed cause 2005-10-11 to be interpreted as YYYY-DD-MM.

Thanks again. I've really learnt something here today.

Of...

Hi Sergiy,

OK, and what determines the DATEFORMAT?

I have executed

select

* from sys.syslanguages

and can see a 'dateformat' field in there....

Sorry Noel. I've just been checking this out and I don't think we've quite got to the bottom of it. Execute the following (I did it after logging on as...

Thanks Noel, I knew you'd have something to say when you came across this

If this is true then my mistake here is that...

Sergiy,

Thanks for that. However, as I said above I already have a workaround that works fine (and in fact the workaround I actually used was exactly as you have given -...

Thankyou for the comments guys.

Ian, the problem first occurred in SSIS (for this is SQL Server 2005) and I then pasted the same SQL into SSMS and managed to repro...

Note if I were you I would get intothe habit of usinng the method I suggested. It will always work whereas using parameterised queries lays you open to the vagaries...

I don't know much about this because I've never had to do it but I do know that Kirk has a very useful post here: http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/10/05/17016.aspx that explains some of...