Please read my post here:http://dba.stackexchange.com/questions/25761/sql-server-2008-datetime-index-performance-bugBasically we can put a SQL comment in front of a query using an indexed datetime order by clause and get something to work that is otherwise not working through ODBC. See samples below.We can reproduce, and can upload a sample database we created (privately) to MS for testing and verification of this bug.Attached is a zip file. You will need to change the destination directory for the database and the location of the text file to load, both are commented in the sql file within.
Operating System Language
Steps to Reproduce