This is probably a stupid question, but what controls the formatting of a datetime column with no cast/convert (in SQL query analyzer or management studio)?

This was a very good question. I did not know that 'true' and 'false' can not be used with bit columns in SQL 2005. I can now stop...

Make very sure that you always add the T-SQL statement SET LANGUAGE ENGLISH before this request.

Living in France, the proposed solution would not work in French, just like a previous post mentions about it not working in German. Relying on the characteristics of a specific...

I think with SQL Express edition their is no Management Studio delivered (the successor to Query Analyzer).  However an command line utility, sqlcmd, is available.  It is not exactly user-friendly...