cengland0 (2/8/2012)
Hugo Kornelis (2/8/2012)
You are aware that mainstream support for SQL Server 2005 has already ended, are you? I'd consider upgrading, if I were you... :hehe:
You're right that the ideal situation is to always have the most current version of the server software installed; however, some of us work with organizations and customers that have outdated hardware and software and we must use what is available.
Hence the word 'consider'. The wider point is that whatever versions of SQL Server we work with, it makes sense to at least be aware that things like DATE exist.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi